VISUALISE variance in Bar Charts // Show Over Target or Under Target // Beginners Guide to Power BI

VISUALISE variance in Bar Charts // Show Over Target or Under Target // Beginners Guide to Power BI

Fernan

1 год назад

17,198 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Supreme Nnn
Supreme Nnn - 29.10.2023 08:28

Cool video. I've changed around the target values to be last years values for my use case. Works fine thanks

Ответить
Karnik Kalani
Karnik Kalani - 13.07.2023 04:12

I want to do the same for margin percentages but its not happening for me it 3 values don't show up as clear as yours. and the percentage also has to be calculated its not in a column as i used a measure earlier

Ответить
Lara
Lara - 20.03.2023 09:12

pls check, keep getting error
Over Target =
VAR _Headcount=Sum(Headcount[Actuals]
Returns
If (_Headcount > Targgggt[Targgggt Value]), _Headcount -Targgggt[Targgggt Value]

Ответить
Lara
Lara - 20.03.2023 08:46

i have 2 dates to compare using bars & its not working

Ответить
Lara
Lara - 20.03.2023 08:46

please comment on this. it's not working for me. than you.
Over Target =
Var DATEFst=SUM(DATEFst[Fst HODate])
if(DATEFstFst [HODate]>DATETargt[],DATEFst[Fst HODate]-DATETargt[Targ HODat])

Ответить
Lara
Lara - 20.03.2023 08:09

thank you very helpful!

Ответить
WelcomeToMathy
WelcomeToMathy - 13.12.2022 19:46

can we do this to show growth difference?

Ответить
Ranga Beeram
Ranga Beeram - 13.09.2022 16:25

Thanks!

Ответить
Sonny Sahota
Sonny Sahota - 12.09.2022 23:41

Hey Fernan. Great video, as per usual. Can you please add timestamps to your videos? Thanks!

Ответить
Arbaz Ahmad
Arbaz Ahmad - 12.09.2022 22:57

Great 👍

Ответить
Billson Hainsley
Billson Hainsley - 12.09.2022 19:28

Thank you! Great technique for a visual that gives the user even more useful information at a glance!

Ответить