Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I'm brand new to Power BI and I'm attempting my first report/dashboard.
My column chart defaults to aggregate (summerize?) my data. I don't want it to do this. I want my value field (ScrapV) to show all individual records for my axis (Scrap Reason). I'm also applying a filter to show only valuse >= 100.
When I go to table view, and select "Don't Summerize" on my ScrapV value field, it shows exactly as I would expect in the table.
How can I do this same exact thing in a colmun chart?
Thank you,
- Justin
Solved! Go to Solution.
@v-piga-msft thank you for explaining. I was able to accomplish something close enough (maybe even better). I just had to stack the data to get individual records not summerized. I also had to add the applicable field to the Value and Legend. Very cool!
Hi @Justair07,
Normally, the value in chart will be the aggregate value.
You could go to modeling tab and set the default summarization to be Don't summarize.
If you still have the aggregate value in chart, I'm afraid that there is no ways for us to show the individual records in chart.
In addition, you could share some data sample and your desired output, may be we could have another way to solve it.
Best Regards,
Cherry
@v-piga-msft thank you for explaining. I was able to accomplish something close enough (maybe even better). I just had to stack the data to get individual records not summerized. I also had to add the applicable field to the Value and Legend. Very cool!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |