Using Slicers To Let Users Toggle Between Count and Percentage Measures In 1 Chart + 1 Table

[ngoldovsky]

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. 

notworking

Is there no way for me to populate a table and a line chart with a selection of multi-formatted metrics?

[Stachu]

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