Dynamically change chart axis in Power BI

In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX.

Chris Cook - @Finalyst89
Scott Senkeresty – @ScottSenkeresty

Dynamically changing chart axis

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

[juancpgo]

I think it would be more useful if you first showed in the videos the final result, so we actually make sense of what it's all about, and then show how you did it.

[culpritdesign]

This is great! I was trying to do some kind of calculated field based on a parameters and it was not going well... now you make me realize I was essentially trying to program the unpivot function...

[kingingway]

Great! Was looking for something like this!! Thank you, Patrick

[hermesjrd]

Patrick a Big Shout-Out to You. This Tip is awesome.

[learnspreadsheets]

Great video! I sometimes get issues with bidirectional filters too, what can I read explaining why they break sometimes?

[calito]

love it the simplicity!!!! Usually solutions like this one involve some tweakys and geekys around the DAX but this one I fetl it simple and straightforward I will adopt it... thks!!!!

[cristian.angyal]

Great video Patrick. Thanks for sharing it!
One small comment though: Marco is also saying that Measures should be written without the Table Name in front as a "Best Practice" :)

[ektaatomar]

I was looking for this solution. Thank you.

[Crack]

Great video!

I have a new challenge for you that builds on top of this dynamic axis solution. I have four data attributes: Cost per Thousand, Cost per Click, Click Through Rate, and Unique Click Through Rate. The first two are dollar figures and the last two are percentages.

My issue is that when a user selects any given column, I need the value on the y-axis to change its type. For example, when the user selects Cost per Thousands the y-axis should display dollar amounts. When the user selects Click Through Rate the y-axis should display percentages.

I've been banging my head against a wall for a couple of hours now.

Keep up the great work!

[bernatduranmascorda]

This is GOLD! Thank you, I'm a huge fan of your channel!

[satishkurra]

What if we have dimensions coming from different tables instead of single table

[ben_habib]

"I went to my favourite search engine... Bing" - I laughed way to hard at this

[joshblackman]

Mind blown. I love the crossfilter. I was just trying to do this in a report, many thanks.

[labbylabby]

Superb ! Such a easy to learn with your tutorials and method .. thank you

[lauroteixeira]

The best and simplest solution! Thanks man !!

[AISHWAR]

Hi Patrick
Guy in a Cube channel is excellent. I always turn onto you guys if need some help.Well, we also had the same requirement for our client and we had used the same logic of Unpivot around 6 Months back.

[sammertalib]

Hi! Amazing video, is there a way to change axis with calculated columns? Tried it but sadly unable to do so. Any suggestions? Thanks!

[Markfriedman]

Hey Patrick. Great videos! But a question on this one... if my source table is refreshed daily from sql server, and my values originate from this table, how do I propagate those changes to the duplicated table and pivoted table from the updated data? Reference table? Thanks!

[AW-ppjg]

Thank you for all the videos; they are fantastic. Is there an alternative/better way of doing this if you have a large data set?

[marcosoliveira]

Still so relevant in 2019.
Tks a lot!