Matrix visual showing URL symbol in totals

[dosania]

Hi,

I have produced a Matrix visual, and it is showing the URL in the total column, which looks very out of sync with the rest of the table. I am not able to use a Table visual due to the construct of the data.

I have tried changing the total colour, but this hasn't changed anything.

Is there a way of turning off the URL symbol in the total?

Below is a screenshot of how it currently looks.

I'd appreciate it if anyone has any works arounds for this.

Thanks

[amitchandak · Accepted solution]

@dosania , use isfiltered or isinscope to do that

If(isinscope(Table[Column]),Max(Table[URL]), Blank())

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/