Multiple Columns Bar Chart

[Bahalzamon]

I have 9 columns I am attempting to put in one stacked/line chart. Essencially I have some scoring values for the 9 columns and want the line to compare it to all the other data not included in the slicers which I have through measures.

Columns: Inventory, Account, Data, Config, Malware, Recovery, Awareness, Provider, Response.

Currently I dropped them all into the "Column y-axis" which looks horible. The 2 green dots are measures grabbing the first and second columns (Inventory & Account) but as you can see they are just centered.

I am wondering how I go about making it look something more along these lines? The data below was all pulled from one column using calculations and works great.

I am unsure how to break each column into its own "Category" and then associate the calculated values to them.

Heres a quick look of the overall visual, there will be another 7 of the _# Average added for a complete picture.

[Ritaf1983 · Accepted solution]

Hi @Bahalzamon 
It happens because the graph is without x axes.

The columns are just a set of measures that you put there.

To make it in the desired form you can create a table for all the measures and use a selectedvalue Dax formula.

Please refer to my solution in the linked post, it includes pbix with example (you can ignore the question because the problem is not like yours, but the solution is the same )

https://community.fabric.microsoft.com/t5/Desktop/Spacing-between-bars-for-clustered-column-chart-th...

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

[Bahalzamon]

Worked perfectly, thank you, below is what mine ended up being. Only down side was that it could only pull in measures into this measure so I had to make measures for all the columns ([_1 Average], [_2 Average, ...]) but that was easy enough.

The Visual.

Code for Measure

_RA Category Avg = 
SWITCH(
    SELECTEDVALUE('_RA Category Table'[Category Short]),
    "Inventory",[_1 Average],
    "Account",[_2 Average],
    "Protection",[_3 Average],
    "Configuration",[_4 Average],
    "Malware",[_5 Average],
    "Recovery",[_6 Average],
    "Awareness",[_7 Average],
    "Provider",[_8 Average],
    "Response",[_9 Average],
    BLANK()
)

Manual Table

[Ritaf1983]

Happy to help 🙂