Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have here the sample PBIX file SampleFile_ColumnSort.pbix
I have added a filter however, the columns with no values are being removed from the matrix. How can I show these columns even if they are empty?
Solved! Go to Solution.
Hi @emman_burgonia
Please find the attached pbix
Let me know, it works or not
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE 👍 this comment/Kudos
Hi @PijushRoy,
Here's the screenshot. The first table is the unfiltered one while the 2nd table I added another filter on it. I was hoping I can still show all the columns in it just like in the 1st table.
Hi @emman_burgonia
Please find the attached pbix
Let me know, it works or not
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE 👍 this comment/Kudos
Hi may I ask the steps you did? I tried creating a new table "country" but it didn't work when I change the country name in the slicer.
@emman_burgonia
Please make realtionship between Country to Country
Check my pbix file
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please THUMBS UP 👍 this comment/Kudos
Hi @emman_burgonia
Can you please share screenshot and hightlight your expected result.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |