I have a data set and a mapping table as below.
In Power BI, I created a slicer dropdown containing words "Finance Lens" and "Business Lens", This is created using table "Lens" and column "Lens Type"
Based on the selection, I want the grouping to change in the below visuals.
I created a new column as below :
Selected_Lens = If(SELECTEDVALUE(Lens[LensType],"Business Lens")="Business Lens",MappingTable[Business Lens],MappingTable[Finance Lens])
But it is not working... Any idea would help.