Club Power BI

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

hide lines with no value in a matrix

  • 1.  hide lines with no value in a matrix

    Bronze Contributor
    Posted Jun 13, 2022 09:49 AM
      |   view attached

    Hi, Folks

    I have a Matrix  with sometimes no values in lines, and would like to hide the whole line in that case . Here you can see 3 levels sometimes, and 2 level some other.
    As a matter of facts,  there is no point in seeing  empty lines in a matrix. Can you make  it work when we have 2 items in the X axis like this example ?

    I attached the pbix file to make it clear.

    Didier Maignan
    Power BI Trainer and Data Analyst


    1.4 Hierarchies v3.pbix   78 KB 1 version