Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Could you please post some sample data and your expected result here?
Best Regards,
Herbert
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).
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |