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,
I have in one of my reports a Matrix VIsual.
This Visual decides to not show the total column anymore depending on how it is filtered.
For example if I filter 50 weeks it shows the total.
If I filter 100 weks it doesnt anymore.
I can't explain this behaviour. Because if I filter 10 calendaric years it shows it.
If I filter 10 years, it doesnt.
So it can't be the amount of columns. Cause the 100 weeks that doent show the total cant be lmore columns then 10 calendaric years.
I can even say 100 calendaric years and it shows it, but switched to years nothing.
Filtered as years it only shows it as long it is just 1 year.
And I change nothing else beside this one filter.
I really don't know what is happening there and how I can solve it.
Of course I could make a separate Table just for total. But this is not rly user friendly. Cause you have to expand a year in two tables and so on.
Greetings Benedikt
@amitchandak @davehus
I think I know what sign you mean, because in the graph visual it is when I show too much data.
But no there isn't in the matrix.
And yes it is fully expanded. It should show all data.
Hi @BeneL ,
Is the visual fully exapanded to show all the data?
Did I help you today? Please accept my solution and hit the Kudos button.
@BeneL , Just is there some sign (!) near to visual or in sub total column? That means data points limit has exceeded and not all data is shown
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |