Creating a slicer that chooses different measures that give percentages

[snow87]

I created some slicers that choose between measures following this guide https://goodly.co.in/change-measures-using-slicer-powerbi/ and it seems to be working. I had to leave the format off to get my line chart to work though. How do I make my line chart display in percentages rather than decimals?

[snow87]

This is the measure I'm using in line chart:

Calculation PID To Be = SWITCH( TRUE(), [User Selection PID To Be]="WH Scrap Rate", [WH Scrap Rate], [User Selection PID To Be]="WX Scrap Rate", [WX Scrap Rate], [User Selection PID To Be]="PX Scrap Rate", [PX Scrap Rate], [User Selection PID To Be]="107 Scrap Rate", [107 Scrap Rate], [User Selection PID To Be]="108 Scrap Rate", [108 Scrap Rate], [User Selection PID To Be]="109 Scrap Rate", [109 Scrap Rate], [User Selection PID To Be]="110 Scrap Rate", [110 Scrap Rate], [User Selection PID To Be]="111 Scrap Rate", [111 Scrap Rate], [User Selection PID To Be]="112 Scrap Rate", [112 Scrap Rate], "Select any single PID To Be" )

[NickolajJessen]

Not completely sure what you mean by this?

---

@snow87 wrote:

I had to leave the format off to get my line chart to work though. 

Is the option to change the format greyed out for you or what is your situation? (When selecting your measure)

[snow87]

My individual measures are all set to percentage. But when I use them without formatting through the procedure in the article I linked above they come out as decimal values.

If I try to use FORMAT() the chart is just blank.

[Dhacd]

Try wrapping the measure in which you want to see as in percentage in the function below.

FORMAT (
        [Your measure],
        "0.0%")

If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
Thanks and regards,

Atma.

[snow87]

So far every time I try to format the output of the measure, it results in the line chart I'm using being blank.