I don't want to show measures like columns if they don't have values

[montoyesco]

Hi,

I have two measures: "Diferencia" and "Variacion".

As you can see, I'm only interested in showing these measures in the totals section, since only here they present values. Therefore, I would like to show these two measures only like Totals. Any help?

[v-haibl-msft]

@montoyesco

Do you have any update about the suggestions above?

Best Regards,
Herbert

[montoyesco]

Hi @v-haibl-msft,

No, I don't. The solutions they proposed do not apply to this case.

[v-haibl-msft]

@montoyesco

Could you please post some sample data and your expected result here?

Best Regards,

Herbert

[montoyesco]

I do not think that's necessary. I already spoke directly with a Power BI advisor and he himself confirmed that what I need is not yet possible in Power BI (although Excel does allow it).

[GilbertQ]

Interesting as I am pretty sure that there would be a way to do it. Sometimes it just means thinking a little outside the box

[GilbertQ]

Hi @montoyesco

What you could do is to create your measure with the following below.

Diferencia  Non Blank = IF(ISBLANK([Diferencia]), BLANK(), [Diferencia])

What that will then do is if the measure has no values, or is BLANK() then make it BLANK (which in Power BI means it will not show any values), otherwise if there is a value then show it.

[v-haibl-msft]

@montoyesco

It seems like you are using the Matrix visual. If you only want the measures in totals section, you can try to create measure to calculate the totals and put them into the Table visual. Then the subtotal will not exist.

If you still have problem on it, you can post some sample data and your expected result here. It will be helpful to solve it.

Best Regards,
Herbert