Power BI Matrix Show Columns even the rows are blank

[emman_burgonia]

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? 

[emman_burgonia]

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. 

[PijushRoy · Accepted 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 

[emman_burgonia]

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. 

[PijushRoy]

@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 

[PijushRoy]

Hi @emman_burgonia 

Can you please share screenshot and hightlight your expected result.