Forum Discussion

josevaras's avatar
josevaras
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Remove 100%

Hello, thank you in advance for your help.  I have the measure below that I am using in a matrix. When I bring the measure in I change it to "% of columns" and it works fine. The issue (my que...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Context of the display is important.

Can you share sample data and sample output.

josevaras's avatar
josevaras
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Your correct, my apologies. Below is a snapshot of visual. As you can see, I get the 100% values returned which is correct, I just prefer to hide them. Thanks


 

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    6 years ago

    Hey josevaras ,

     

    did you check the measure I suggested, Power BI will hide empty columns automatically from the matrix visual if the column is blank (also the Total line), except the option "Show items with no data" is checked for the column used as column header/axis label.

     

    Maybe you want to consider creating a pbix that contains sample data, but still reflects your data model, upload the file to onedrive or dropbox and share the link.

     

    Regards,

    Tom