Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi!
I was wondering if anyone knows how to add space between the columns in the 'Clustered column chart' when using only calculated measures?
It seems like unless a value is applied to the Axis value all the values gets grouped together with no spacing. In my case the values cannot get categorized using a column in the Axis and counting number of rows as a a row can be of more than one category.
I have seen some creative solutions such as adding a measure with blank and removing the measure name. But it seems like Power BI no longer allows you to have a measure without a name (https://community.powerbi.com/t5/Desktop/Spacing-in-column-chart/m-p/423550#M194799).
Does anyone know how I can add spacing to 'Clustered column charts'? Is there another visual that would solve this?
Best regards
Arefoss
Hi @Anonymous ,
You can refer to the following steps to grouping your measures and use them in the clustered column chart.
Steps:
1. Create a table with all types of measures.
Table= SELECTCOLUMNS({"a","b","c","d","e"},"Category",[Value])
2. Write a measure with switch function to use above table category to return correspond measure value.
Measure =
SWITCH (
SELECTEDVALUE ( 'Table'[Category] ),
"a", [Measure a],
"b", [Measure b],
"c", [Measure c],
"d", [Measure d],
"e", [Measure e]
)
3. Create a clustered column chart with the above category column as axis and legend, measure as value.
Regards,
Xiaoxin Sheng
Hi!
Thanks a lot for your answer!
Your solution does solve my issue on my test set. But I am having trouble when applying it to a SSAS connection. When I try to create a Calculated table in SSDT I recieve an error message: "Could not complete the operation because the changes could not be committed to the VertiPaq engine."
Do you know of work around or how I could solve this.
Hi @Anonymous ,
Current I haven't found any methods to create a table on live connection mode. Maybe you can create a table on your database side to stored all category, then you can use its axis and category on your visual.
Regards,
Xiaoxin Sheng
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |