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.
I am fairly new to BI so I apologize if this question has been answered before, I was unable to find it. When I go to show data point as a table for certain elements, the resulting table has all 0 values in the column that was summarized. For example, this is a simple sum of values
I can manually set the field in the visualization to display a max value, for example, and regain those 0 values. However leaving the visualization resets this for the next "Show Data Point" and I would prefer if the end-user did not have to alter any fields in this manner. Does anyone have any tips on how to fix this?
Solved! Go to Solution.
HI @Beefhamburger ,
When I show data point as a table I see the right results. See below:
I am using a summarisation on my value field as well:
Hi @Beefhamburger ,
First question - What version of Power Bi are you using?
Second question - I tried replicating this at my end and seems to work. Can you add more details to the underlying data on the pie-chart visual please?
I am using the newest version of BI Desktop. In your demo, you are "showing the data as a table" which works fine on my end and displays the data for the chart in tabular form. What I am trying to do is show the underlying records in the data itself with "show data point as a table." That is where the zero values are introduced on each record for the field I summarized in the chart. I am sure it has to do with the chart being a SUM metric, but I'm not sure why the underlying records then have all 0 values in the column I am looking at. Again, I can go to the visualization column in question and set it to another function and regain those values but I'm not certain why it's not simply displaying the actual underlying records.
HI @Beefhamburger ,
When I show data point as a table I see the right results. See below:
I am using a summarisation on my value field as well:
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |