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 Used F&I are measures calculated in the dataset. I am able to pull them in a clustered column chart, however I cannot see any customization to have a SPACE in between 4 different items.

The below chart is what I get:

 

How can I have a space between all those 4 different category measures? Any idea would be appreciated!

 

Thanks!

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.

3 Replies

  • 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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    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.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    Hi Anonymous 

    Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
    really appreciate!
    Any question, please let me know. Looking forward to receiving your reply.

     

    Best Regards,

    Community Support Team _Tang