Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
How can I remove a column which have null values from a table.
Both rows and columns coming from two different measures.
Hi @jatneerjat ,
Is the screenshot a Table visual or Matrix visual?
If it is a Table visual, now that that column or measure returns empty value, why not directly remove it from visual?
If it is a Matrix visual, you could apply "Visual Level Filters" to filter out empty records.
For more advice, please provide dummy data and necessary mesure formulas you used. How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
Go to Data model.
Rigt Click column
Delete
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |