Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Column Chart with Multiple Category Calculated

Hello Team,   I am trying to display a column chart representation as below image: The challenge that I am facing is - all these ACT and BU values of New Margin, Used Margin, New F&I and Use...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    check the structure of your data, and ensure the data has correct structure.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous You want to use a disconnected table for your Axis. Then you can create a single measure that determines which measure to show based upon the value in the Axis. For example:

Measure to Show = 
  SWITCH(MAX('AxisTable'[Column],
    "New Margin",[New Margin],
    "Used Margin",[Used Margin],
    "New F&I",[New FI],
    [Used FI]
  )

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563