Column Chart with Multiple Category Calculated

[Sashwato]

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!

[v-xiaotang]

Hi @Sashwato 

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

[v-xiaotang · Accepted solution]

Hi @Sashwato 

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]

@Sashwato 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...