Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using SELECTEDVALUE and SWITCH functions with a slicer without conection is possible to create a chart showing dynamically these measures.
Solved! Go to Solution.
Thanks @v-xuding-msft,
The way I've found is to have two dynamic slicers (one for the KPIs) and other for the KPIs threshold, considering that which KPI has a different threshold, tricky one! So you have to select the KPI and the threshold manually. It would be nicer I could having one slicer selecting both (KPI and KPI threshold in one shot)
Cheers!
Hi @Anonymous ,
Maybe you can try to add the measure to visual level filters to implement filter values after filtering with slicer.
If it is not what you want, can you please share the sample data and the expected output? Then we can find a way to implement add more than one measure in each selection. According the present statement, I think it is difficult to create a sample to implement it.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-xuding-msft,
The way I've found is to have two dynamic slicers (one for the KPIs) and other for the KPIs threshold, considering that which KPI has a different threshold, tricky one! So you have to select the KPI and the threshold manually. It would be nicer I could having one slicer selecting both (KPI and KPI threshold in one shot)
Cheers!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |