Displaying measures as percentages in Power BI charts - Unplugged #43

How can you display the measure as a percentage in a chart where the Y-axis shows the value? With the smart techniques shown in this unplugged video!



#unplugged

[cesc]

Glad to see that even Alberto is also struggling finding stuff in the new format pane! Such frustration!

[TheSagatik]

Thank you a lot. You helped me so much👍

[aditiiyer]

Excellent trick, Alberto! Thank you for sharing

[cognovo]

Thank you for the interesting video. I did not know that a calculation item can replace the Formatstring expression of a measure. Always thought that only a value could be replaced. GREAT, thank you for this insight.

[ceksbzl]

@SQL BI, First of all thank you to all interesting videos that you shared. I was gone through this video when it was uploaded but now current Power BI feature that is custom labels, we can solve it much easier way.
I remember your videos when i apply custom labels in Power BI.
Thanks

Asteroids % =
VAR total_ast =
CALCULATE(
[Asteroids #],
ALL('Fact'[Size]))

VAR Result = FORMAT(DIVIDE([Asteroids #], total_ast, BLANK()), "#, 0%")
Return
Result

[ankitassmallworld]

Extremely good. kindly post more similar videos on power bi.

[Anthony_Lecoq]

Just astomished, thousand thanks for those tips Master Alberto ;)

[bentatlim]

Thank you very much, for this amazing Video ❤ I try that since 3 days 😮‍💨 I LOVVVVEEE 🤣 Kind Regards from Berlin

[why-bi]

This is really helpful. I will try this Trick in one of my Next Reports 😀

[badrGamer]

Thank you for the quality content one of the best. Keep up the good work

[adilmajeed]

Awesome, for the similar way we can show the time hh:mm:ss on the line or column charts using calculation item format strings

[pawewrona]

I never though about presenting the graph like that. Thank you for the Video!

P.S. I though I knew the answer right away, but then, I would do the same mistake, which you are fixing later on :D Very useful trick :)

[hiteshpadal]

Nice trick 👍. This could be a simple toggle button in formatting pane rather than the use of an external tool 😅. @microsoftPowerBITeam, hoping this will get implemented as a built-in feature.

[jameszhang]

Cool as always, thx Alberto. I got a question is that the original charts' values axis is shown on the left, how to make it?

[elchin]

Thank you Alberto for a useful video! I am curious what is your microphone? Have you really recorded this video with the headset microphone as seen on you?

[danielskrobowski]

@sqlbi Why doesn't this work if, in the format-string expression, we simply use ISFILTERED (or a similar method) to check if either year or size is being filtered instead of relying on the secondary axis for the visual. In this scenario, shouldn't the primary axis remain in regular units since the axis isn't being filtered by year or size?

[celinemadore]

We could also use Charticulator visual to build it quite easily.🙂

[youness]

Thanks a lot :-) Very interesting, please how can we get the dataset?

[jemsuper]

Very cool, sadly i cant use tabular Editor. Always sad when Excel build in functions arent found in Power BI

[akhilannan]

How come the calculation group format didn't get applied on secondary axis eventhough same measure was used?