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,
In PowerBIDesktop or Excel
how can you write a DAX SWITCH formula that would switch over Statuses of different KPI's. So sort of
=SWITCH( [SwitchMeasure], [StatusOoKPIOne, [StatusOfKPITwo],...)
where KPI's were imported from Excel...
So to see the icons for the selected measure...
ur requirement is quite no clear, can you be more specific?
Ok, so in a Data Model in Excel you have a bunch of measures and a bunch of KPI-s defined for those measures.
And then, instead of vasting many columns of valuable workspace, you use a disconected slicer method, so that you can easily change the calculation (so still have them all available), you wish to see and only use one column of real estate
Now with calculations this works great... My question however is, if you can write a magic SWITCH formula (or use another function) to use only one column on the KPI statuses (the icons).. Something like
but with some sort of magic dust 🙂
HI @ExcelUnplugged, You can indeed do this in DAX, it works in Power BI, where you defined the KPI in separate measures, and chain them together in a single switch statement, based on a table of measure names (this config is a bit manual but it works).
The Selected Measure is a Measure over a list of measures : Selected Measure = SELECTEDVALUE('Measure Table'[Measure Column])
Then the flexible KPI is:
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |