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

[Anonymous]

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.

[Nathaniel_C]

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]

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]

@Anonymous ,

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

Nathaniel

[Anonymous]

@Nathaniel_C Sure! Please find it through the link https://we.tl/t-g3S53gA2NR

[Anonymous]

Hi @Nathaniel_C, any tip?

---

[Nathaniel_C]

Hi @Anonymous ,

I worked on this, but didn't get anywhere.  Then just now was thinking it might have something to do with the hierachy, tried to go around that but generating a column that gave Month Name, but still didn't get it.  

Maybe @jdbuchanan71 has some insight? 

[jdbuchanan71]

Even if you force the average measure to return a blank with something like this.

Avg Visits = IF ( ISINSCOPE( 'Table'[Month].[Mês] ), BLANK(), AVERAGE( 'Table'[Qtd Visitas] ) )

It will still show the blank column under every month.

PowerBI does not seem to like asymetric reporting (visits on the months but visits and average on the total).  The best I have found to do is make the extra columns narrow enough that they don't show up.