Forum Discussion

emman_burgonia's avatar
emman_burgonia
Frequent Visitor
3 years ago
Solved

Power BI Matrix Show Columns even the rows are blank

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...
Need Help
Show and Tell
  • PijushRoy's avatar
    PijushRoy
    3 years ago

    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's avatar
emman_burgonia
Frequent Visitor
3 years ago

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's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      emman_burgonia
      Frequent Visitor
      3 years ago

      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's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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