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 |
01-03-2020 | B | FIXED | ASIA | BB | AB | 1000 | 30000 | 200 |
Now i want to create a chart that dynamically change to either show CALL_COUNT or DURATION or AMOUNT. Whenever i tried using selectedvalues, it is not enabling me to choose either CALL_COUNT, DURATION or AMOUNT. They are not measured column rather is data value. How do i achieve this using a dynamic slicer or any other option?
Appreciate any help
regards
deven
Solved! Go to Solution.
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
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
You can refer : https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
You need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
216 | |
57 | |
49 | |
46 | |
45 |
User | Count |
---|---|
267 | |
211 | |
113 | |
82 | |
71 |