Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I have a dashboard which contain table matrix and contain hierarchy.
I have 3 measure (actual, plan and variance). User want to filter rows from table matrix which has 0 in all columns.
I created a new measure (zero-flag= actual + Plan) so if both plan and actual would have zero then zero-flag would contain 0 else some value.
I used this flag in my power bi report "page filter" section.
after adding zero-flag in page filter section report is taking ages to load while earlier it was loading in 5-25 seconds only.
Is there any way to filter zero values rose from table matrix?
Thanks in advance.
Prashant
The performance issue resolution needs some deep dive into the actual pbix. Can you share the power bi file so that I can help you on this
Regards,
Affan
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |