Slicer as measure - select particular measure based upon slicer selection.

[Anonymous]

Hi,

I am having a requirement, In power bi 

I am having a slicer sales & quantity , so when i select sales only sales measure like (YTD  sales,current sales,previous sales) should be visible. if i select quantity (YTD Quantity,YTD Current Quantity,Previous Quantity) should be visible.

YTD sales,Current sales, Previous sales , YTD quantity,Current Quantity,Previous Quantity are measure used in the report.

[Sales , quantity] slicer table is a  disconnected table. 

my requirement is like 

If(slicer="Sales",Filter(Ytd Sales,Current Sales,Previous Sales),
filter(YTD Quantity,Current Quantity,Previous Quantity))

Im a bit stuck can anybody help me out?

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

For your need , you can refer to this solution:Re: Sorting Calculation Group within Headers - Microsoft Power BI Community

1. Create the table Topic with each topic and its associated measure names:

2. Create a fields parameter with each measure listed in the table above. Uncheck "Add slicer to this page".

3. Create a relationship between Topic and TopicParameter. The default is bidirectional, but I changed it to unidirectional (I avoid bidirectional relationships whenever possible).

4. Create a matrix and add TopicParameter to the Values field well:

5. Create a slicer using Topic[Topic].

6. Sort by any matrix column:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , Consider field parameters or calculation groups

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

check video link below

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0