Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, have matrix with 4 levels hierarchy and majority of scenarios Level 4 is blank/NULL. But Matrix is still displaying a empty row.
so I used ISINSCOPE to remove BLANK rows as suggested by Curbal.
https://curbal.com/blog/glossary/isinscope
and it's working as expected on the Matrix visual.
But there is one issue when am trying export from Visual using 'more options'. Power BI is exporting only rows with level4 is NOT NULL/NOT BLANK even though Matrix is displaying correct.
please help.
Hi @Anonymous
As tested, if my source table is as below
Then my matrix is as below
The export format is as below
Is this what you expect?
Not exactly @v-juanli-msft
Please find attached pbix file and sample file.
try to export from Matrix Visual and compare with what you see on the report.
https://1drv.ms/u/s!Ai0GzdHCLgzPkwJunB1gzAdC7a03?e=2Vrlz1
Hi @Anonymous
When I export to data, it shows data with filters from Power BI.
So the row for District 2, Country 5 is missing for this row has no "city" and " value" row.
Do you want the exported data without applied filters, just show all data as stored in Power BI data model?
@v-juanli-msft Yes, when I export, I still want to see District 2 and 4. because there is data exist for these levels.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |