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.
I have a table which has decimal numbers as portions of hours. The grain of the hours is per entry; N number of time entries can be entered for a calendar date. When I create a table with the value set to Do Not Summarize, time entries with the same value are missing (distinct). When I add the value with the Sum aggregation the hours sum properly.
Solved! Go to Solution.
Hi @JasonMJones ,
Power BI shows the data in two ways ...
1. as aggregable value. (e.g. SUM)
2. as category (distinct)
... that's how it is at design.
If you want to see each entry \ value, something must be displayed that differentiates the values.
You can use do not summarize in a table, not in the matrix. That might not help in this case.
Create an index column and add that (Not Summarized )
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448
Thank you for your quick response and the suggestion, but I am using a table in the example.
Hi @JasonMJones ,
Power BI shows the data in two ways ...
1. as aggregable value. (e.g. SUM)
2. as category (distinct)
... that's how it is at design.
If you want to see each entry \ value, something must be displayed that differentiates the values.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |