Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Hide specific row but it shouldn't impact the totals from the matrix

    Posted 12 days ago
      |   view attached

    Hi,
    I would like to check if there is a way to hide a specific row from matix but it should impact the subtotals and totals?
    In my case I want to hide Misc product from matrix but it should not impact the City, State and Country.

    Also, I want to display only subtotals and totals not the values. I wrote the measure to display only subtotals and totals. But wanted to see if I can hide Misc from matrix without impacting totals.

    I have attached the pbix file.



    Thanks in advance.



    ------------------------------
    Navya K
    ------------------------------

    Attachment(s)

    pbix
    Test.pbix   28 KB 1 version


  • 2.  RE: Hide specific row but it shouldn't impact the totals from the matrix

    Posted 10 days ago
      |   view attached
    Veja se esta alternativa ajuda:

    1. Diminuir a largura da coluna "Product" até ficar zero;
    2. Criar a medida abaixo:
    Products = 
    IF (
        SELECTEDVALUE ( Sheet1[Product] ) <> "Misc",
        SELECTEDVALUE ( Sheet1[Product] )
    )​

    PBIX em anexo

    ------------------------------
    Vilmar Santos
    ------------------------------

    Attachment(s)

    pbix
    Test.pbix   28 KB 1 version


  • 3.  RE: Hide specific row but it shouldn't impact the totals from the matrix

    Posted 5 days ago
    Edited by Navya K 5 days ago
      |   view attached
    Hi Vilmar,
    Thanks for the reply and it worked.
    I have implemented similar solution later.
    1. Created a measure custom1=IF(SELECTEDVALUE(Sheet1[Product])="Misc",BLANK(),SUM(Sheet1[Sale Amount]))
    2. used this measure in the values.
    3. unselected show items with no data

    This actually hidden Misc product without impacting the complete totals,


    Thanks Navya.

    ------------------------------
    Navya K
    ------------------------------

    Attachment(s)

    pbix
    Test (2).pbix   27 KB 1 version