Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm not sure if I'm just used to desigining things in a different way, but it appears to me that PowerBI is rather limited in giving report developers the ability to leverage single charts that could display a dynamic selection of segments and metrics.
Most of the solutions I found to toggle between measures in a viz indicate the need to set up a separate metrics table and then utilize a SWITCH function to switch between the measures you want.
e.g. https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
However, in my example, I have two count measures and one percentage measure.
When my SWITCH measure is like this, the "repair rate" measure is formatted as an integer and appears as a 1 or 0 in my table.
Repair Metric Select = SWITCH(TRUE(), VALUES('Repair Metrics'[Metric])="Installs With Repair",Query1[Installs With Repair], VALUES('Repair Metrics'[Metric])="Installs W Multiple Repairs",Query1[Installs With Multiple Repair], VALUES('Repair Metrics'[Metric])="Repair Rate",Query1[Repair Rate], BLANK())
Like so:
However, when I format it like this:
Repair Metric Select = SWITCH(TRUE(), VALUES('Repair Metrics'[Metric])="Installs With Repair",Query1[Installs With Repair], VALUES('Repair Metrics'[Metric])="Installs W Multiple Repairs",Query1[Installs With Multiple Repair], VALUES('Repair Metrics'[Metric])="Repair Rate",FORMAT(Query1[Repair Rate],"0.0%"), BLANK())
My table values show up correctly but my line chart will appear blank.
Is there no way for me to populate a table and a line chart with a selection of multi-formatted metrics?
you can do that with multiple overlaying charts (some not visible) and bookmarks, see here
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |