Forum Discussion
Multiple Columns Bar Chart
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 )
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 )
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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
Happy to help 🙂
