Dynamic chart axes via parameter or switch

[Anonymous]

Hi I watched partrick's dynamic axes video and wondered why we can do it using a DAX formula that has a switch on it based on a value from a table or parameter.

https://www.youtube.com/watch?v=n-OWNaCUU0o

It would make a big improvement to power bi. This is what i commented on his video:

Hi Patrick my friend, i tried creating a dax var with IF(selectedValue(Test[Value])=1,Format(DateCol,"MMM"),ProductType) and stuck that into the x-axis of a bar chart and unfortunately even though the code was sound (no errors) the switching didnt work. Test is a table with values 0 and 1 only and was using it to switch axes. If MS can get this working it would be great i think.

REPLY

[v-yuta-msft]

@Anonymous ,

---

IF(selectedValue(Test[Value])=1,Format(DateCol,"MMM"),ProductType) and stuck that into the x-axis of a bar chart and unfortunately even though the code was sound (no errors) the switching didnt work. Test is a table with values 0 and 1 only and was using it to switch axes. If MS can get this working it would be great i think.

---

I'm not very clear about your description, how can you drag the measure to the X-axis bar chart?

Regards,

Jimmy Tao

[Anonymous]

By putting it into the Axis bin just above the Legend bin. Simple