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.
Hi guys,
I creating a Matrix Visual, something like below :
For which, the row listed my Resources name getting from my FactTables, which obviously has value in certain Quarter which spread column wise in that matrix.
I also have a different table, which is a Target Table, with data like this :
Year | Target |
2019 | 50 |
which has no direct relation to my Fact table or my Resources dimension, the only relation is the Year connect to my Date dimension [Year]
Problem arise, when I add the Target to this matrix, it will display my whole Resources provided it has no record in my Fact Table. resulting the matrix shows many empty / blank rows.
How am I going to hide or remove this, so it will still display the Resources (or data) from my Fact table only.
Thanks in advance,
Solved! Go to Solution.
Hi admin_xlsior,
You can select the matrix visual, and go to Visual Level Filter pane, do an advanced filter to choose "is not blank" to filter the blank rows out.
If you have any other issue, please feel free to ask.
Best Regards,
Amy
Hi admin_xlsior,
You can select the matrix visual, and go to Visual Level Filter pane, do an advanced filter to choose "is not blank" to filter the blank rows out.
If you have any other issue, please feel free to ask.
Best Regards,
Amy
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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |