Hi!, I have a table that has the option to show totals values hidden, and this works fine in Power BI Desktop, even when I select the "Show as table" option. But, when the report is uploaded in Power BI Service, the total appears when I select "show as table", is it possible to hide this total? or will it be due to a Power BI service error?.
This is an example (I cannot show real data due to privacy issues)
Hi, @gustavo_rivas
After testing, or you can try the following methods to hide total.
Measure 2 = IF(HASONEVALUE('Table'[ID]),SUM('Table'[Value]),BLANK())
In the Power BI Service show as a table:
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @gustavo_rivas
After testing, or you can try the following methods to hide total.
Measure 2 = IF(HASONEVALUE('Table'[ID]),SUM('Table'[Value]),BLANK())In the Power BI Service show as a table:
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
