Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic chart axes via parameter or switch

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
 
 
Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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