The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Here is my table:
Both Alertcount and OkCount are whole number columns with dont summarize. When I add these to the 100% stacked chart they go as COUNTS. Why would I want to count these values? I want values. Any idea?
Thanks
Hi @Markzolotoy,
It seems like you setting the numeric field with the 'do not summarize' mode. It will ignore the default aggregate, but it not means they can directly use visual charts that required value summary. Power bi will aggregate them with 'count' mode. (similar to text type field)
For this scenario, I'd like to suggest you reset them to default and add more categories to your chart, then power bi will auto-summary and split these values based on different category and legends groups.
Regards,
Xiaoxin Sheng
That's why this product is so difficult to use.
@Markzolotoy , every tool has its own way to deal with things. If you let us know what you are trying to do(with example), someone in the community will be able to help.
@Markzolotoy , All the visuals will need aggregated columns/measures in Values(other than axis and legend). So if you do not give summarization, default is count.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |