Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to hide columns from a matrix, keeping just the Total

Hi! Do you have any tip to solve this issue?

I need to create a table like the one attached (Store vs. #Visits per Month) and add a column with the average of the months.

But when I do this, Power BI applies the Average for each column, each month. And I would like it to include only 01 more column in the report.

7 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous , would you give us a little more detail?

    You drop the column Noma da Loja on the matrix, and then what?

    Thank you,

    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Nathaniel_C

      Actually the problem are the columns. When I drop the "Average Visits" measure, it splits the columns of each month (June, July, August) into "Qty Visits" and "Avg Visits".

      But I need to have a table where: each month only shows the column "Qty Visits"; Totals shows both "Qty Visits" and "Average Visit".

      Nathaniel_C wrote:

      Hi Anonymous , would you give us a little more detail?

      You drop the column Noma da Loja on the matrix, and then what?

      Thank you,

      Nathaniel

       

      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Anonymous ,

        So it sounds like the Average Visits measure is the problem. Would you be able to share that with us?

        Nathaniel