How to hide the matrix if nothing is selected on Map visual

[Anonymous]

Hi All,

On the report page, i have a Map and Matrix visuals. The functionality is, initially when the page loads, we see only the Map visual, but when we click on any location/Dot in the Map, the matrix appears with filtered results.

This functionality is being achieved by creating a custom column and placed it in the table visual and set the filter condition to is 1.

Filter = IF(CALCULATE(DISTINCTCOUNT(Filtercolumn),ALLSELECTED(filtercolumn))=1,1,2)

Now the issue is, using above approch we can hide the matrix, but can't hide the Row header. In my case the row header is "City" and my page initially look like below.(This is the situaltion when we haven't click on any Dot in Map visual)

Please let me know how can we resolve this.

Thanks

[ChandeepChhabra]

I am not sure if Dynamic headers are possible in Power BI, but you can play a trick

1. Make a card visual 
2. Put it on top of your "City" Header in the matrix
3. In the card visual drag the following measure

Dummy = IF(HASONEVALUE(Data[City]),"City","")

This will show a blank when nothing is selected on the Map

[Anonymous]

Hi @ChandeepChhabra,

Thanks for your reply.

I have tried your solution. It gives me  value "City" on the Card Visual, if nothing is selected on Map. When we make a selection, Card visual gets hidden and all the Matrix populates as expected.

Please advise.

Thanks