Reply
Frequent Visitor
Posts: 9
Registered: ‎06-07-2017

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

Hi,

 

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

 

PowerBI.PNG

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?

Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

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

@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

Super User
Posts: 2,925
Registered: ‎06-24-2015

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

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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

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

@montoyesco

 

Do you have any update about the suggestions above?

 

Best Regards,
Herbert

Frequent Visitor
Posts: 9
Registered: ‎06-07-2017

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

Hi @v-haibl-msft,

 

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

Super Contributor
Posts: 4,721
Registered: ‎07-08-2016

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

@montoyesco

 

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

 

Best Regards,

Herbert

Highlighted
Frequent Visitor
Posts: 9
Registered: ‎06-07-2017

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

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).

Super User
Posts: 2,925
Registered: ‎06-24-2015

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

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
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"