Combining Field Parameters and Conditional Formatting

[@karinamatvejeva3164]

I’m so happy that I found You! Thanks a lot!!!🔥🔥🔥

[@dganalysis]

Thanks, stay tuned for more 👍

[@MrTurt99]

Gonna tuck in to this later, good stuff

[@dganalysis]

Enjoy....Let me know what you think 👍

[@Hemantshyontry]

excellent man..

[@Theoriginalsaxocomedy]

Great stuff again, boss. It's always good to learn new things.

[@dganalysis]

Great, working on the next one....👍

[@SSM_33]

The brilliant Hands

[@DatawithHimanshu]

Very Informative. Thank you

[@dganalysis]

You are welcome! More coming soon

[@Jz-ls4lc]

🎉🎉

[@souravthakur9793]

Hi Gerard!
Thank you for creating this video.
I had a request. Can you also create a video on how you created the telecoms churn analysis in Mavens Challenge? I read through your blog and got a hold of some parts. However, I am more keen on learning how you created the final visualization step by step. I would love to recreate that once you have a video on it. Or, if you already have a .pbix file or a link where it sits, could you please share it with me?

[@dganalysis]

I'll add showing normalised data to the list for future videos.

[@Filip.S.]

hey Gerard, thanks for sharing
why did you go with field parameters instead of a detached table with just names? ease of creation?

[@dganalysis]

Thanks, are you referring to creating a parameter list for the three measures?

[@Filip.S.]

@@dganalysis exactly, it works as a slicer with a SELECTEDVALUE anyway

[@osanyinayodeji6741]

Hi Gerard, great presentation and lovely new trick to learn. I was following through the tutorial and i dont know what i did wrong but my slicers for Max parameters does not work. I followed all through the steps here and on medium

[@dganalysis]

Hi, what is not working? Is it the parameters? Can you copy and send me your calc for the net revenue?
I'll try and help you solve it

[@osanyinayodeji6741]

The slicer for the all the max parameters are not working.
Net Order Revenue =
SUMX(order_details,
order_details[unitPrice]
* order_details[quantity]
* (1-order_details[discount]))
Colour Format Employee Rev Bar =
var var_1 = [Max Revenue]
var Result =
If(var_1 = [Net Order Revenue], "#45788c", "#e9e9e9")
Return
Result
Conditional Format Bar Chart =
Var Var_1 = SELECTEDVALUE('Max Parameters'[Max Parameters Fields])
Var Result =
SWITCH(TRUE(),
Var_1 = "'Bullet Rev Chart'[Max Revenue]", [Colour Format Employee Rev Bar],
Var_1 = "'Bullet Rev Chart'[Max Orders]", [Colour Format Employee Order Bar],
Var_1 = "'Bullet Rev Chart'[Max RevPO]", [Colour Format Employee RevPO Bar])
Return
Result

[@dganalysis]

@osanyinayodeji6741 take a look at the conditional format bar chart calc.
I don't think you will be referencing "bullet chart". You should be referring to the calcs you are creating.
I think you will be getting an error for this one.

[@osanyinayodeji6741]

@@dganalysis Worked like charm...........Keep up the good work

[@dganalysis]

@@osanyinayodeji6741 Thanks, glad it helped. I will update the blog post, as it might be a bit confusing

[@narendravishwakarma4646]

I was looking N number of videos and ended up with video which solve my problem almost 😄.
But I was trying to make similar way for scatter chart but using created measures in X-axis & y-axis and ended with no results
Que - How I can make dynamic X & Y-axis based on measure where X-axis has measures X1, X2, X3 & Y-axis has measure Y1, Y2, Y3. Let say if I select X1 than automatically Y1 will select in Y-axis and same for X2 & X3. Is it possible in Power bi