"Dynamic" formatting (not the conditional formatting as available)

[Anonymous]

Hi, I searched the forum but didn´t find my question already asked so far.

I am using financial data and created a slicer that let´s the user select the measure he wants to see in let´s say a table e.g.

• Actuals (in k€, no digits after the decimal point)
• Difference vs. budget or previous year (in k€, 1 digit)
• %Actuals of budget or of previous year (in %, 1 digit)
• ..

I already created a dynamic measure that displays the selected value e.g.

"DynMeasure= switch (slicerval; 1; [actual]; 2; [DiffVsPY]; 3; [%ActVsPY];blank())

When I format the measure as "auto" I get

1: 1000

2: 10.23

3: 0.04

What I want is something like

1: 1000

2: 5.1

3: 4.2%

I want to set the format of my single measure dynamically based on the slicer selecting which underlying measure to show.

Furthermore, for a different case, I have only one measure but the format should adapt dynamically based on the value:

20

15

10

9.5

1.1

0.95

0.051

The smaller it gets the more decimals I want to show. So it is not the conditional formatting which is about coloring.

Any idea how to solve this?

Cheers

Alexander

[v-caliao-msft · Accepted solution]

@Anonymous,

One measue can only have one format. In your scenario, you need to the measure shoule be changed automatically based items selected in your slicer, this requirement cannot be done currently. 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Thank you for your understanding.

Regards,
Charlie Liao