Forum Discussion
dkrishnan
6 years agoFrequent Visitor
Power Bi Dynamic Slicer
HI I have a table with as per below: DATE_CODE PARTNER REVENUE_TYPE HUB PRODUCT COMPONENT_DIRECTION CALL_COUNT DURATION AMOUNT 01-03-2020 A MOBILE EUR AA AB 2000 40000 500 ...
- Anonymous6 years ago
HI dkrishnan,
You can create a new table with all measure field names and use this table field on a slicer.
After these steps, you can write a measure formula to compare current slicer seleciton and use with switch function to redirect current value to specific measure formula results.Calculate table:
Selector= {"Measure1","Measure2","Measure3"}Measure:
Measure = SWITCH ( SELECTEDVALUE ( Selector[Value] ), "Measure1", [Measure1], "Measure2", [Measure2], "Measure3", [Measure3], Sum(Table[Amount]) )Regards,
Xiaoxin SHeng
amitchandak
Super User
6 years agoYou can refer : https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115