Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
When creating a visualization of a "Matrix" and I select a column to use as my "Values", and then I select "Count" (number of widgets), it displays the count without commas breaking up the thousands.
I have tried creating a measure
WidgetTypeCount = count([WidgetType])
that I could then select thousands separator on the modelling featureset - but I was not able to put this measure in the "Columns" space on the Matrix properties.
Does anybody know of a way to do this?
WidgetTypeCount = COUNTA([WidgetType]) if you are counting text values, it works, not
WidgetTypeCount = count([WidgetType])
HI @kiltannen,
>>that I could then select thousands separator on the modelling featureset - but I was not able to put this measure in the "Columns" space on the Matrix properties.
Nope, current matrix not support use measure in row and column field.
You can try to use column in value field with summary mode 'count', then turn on the thousand separator option on modelling tab.
Regards,
Xiaoxin Sheng
yes you are right. I tried to do that but what if column contains text value and I am using count of that column then how can I apply comma in that situation.
Thousands separator is NOT displayed on a column that is summarized as count.
The only way to achieve it is to use a measure - however, as pointed above, you can only use the measure as matrix values.
It would be a great improvement if formatting options work regardless of summarization type.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
60 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |