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.
Hi All,
I am new to calculation groups so still learning and hoping I can get some help.
I have a measure table that simply swaps out measures using SWITCH statements to other explicit measures based on the table selection. I have over 150 measures in this table and I want the user to be able to select them dynamically. So far so good.
The problem is that some of them should be formatted as whole numbers and some as percentages. So it seems like a natural job for calculation groups except the only examples I have seen for calculation groups are using explicit measures. Here, I need to essentially qualify the result based on the selection in the measure table. I tried using ISSELECTEDMEASURE but the name used is the master KPI measure. Seems very basic yet so elusive. How can I use the measure as selected from my table and then format it using calculation groups?
Thanks!!
Solved! Go to Solution.
@DQuigg , refer if these can help
https://www.esbrina-ba.com/calculation-groups-and-conditional-formatting-yes-its-possible/
https://blog.enterprisedna.co/conditional-formatting-in-calculation-groups-power-bi/
https://www.youtube.com/watch?v=TpD57zS2sQU
Thank you @amitchandak !!
The first one looks reasonably close. I will need to kind of walk through it piece by piece.
@DQuigg , refer if these can help
https://www.esbrina-ba.com/calculation-groups-and-conditional-formatting-yes-its-possible/
https://blog.enterprisedna.co/conditional-formatting-in-calculation-groups-power-bi/
https://www.youtube.com/watch?v=TpD57zS2sQU
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |