Is there any way of hiding a visual while no object is selected?

[Anonymous]

Hi guys! I´m building a new report for my boss. This report takes projects titles, amounts, dates, etc from a database.

I had constructed a table which includes the Project Code, Amount and Signer.

I want to know if there is a possibility of adding another table that shows the project description, dates and area WHEN YOU CLICK the project name in the first table I had created.

Thanks for your help!

[Greg_Deckler]

You can do this using measures like this:

M1 Address = IF(HASONEVALUE(DISTRICT[ADDRESS]),VALUES(DISTRICT[ADDRESS]),"")

Take a look at the PBIX file I created here:

https://community.powerbi.com/t5/Data-Stories-Gallery/Ohio-Primary-and-Secondary-Education-Performan...

On page 2 (District Comparison) you can click on a bubble and you will see information displayed to the right of it but otherwise it is blank.

[Anonymous]

Thanks for your reply! But I think this solution might not help me.

The initial state of your report shows the table but with a " " value. I need the possibility to hide the table at all when nothing is selected. I'm feeling this is not possible...

[v-huizhn-msft]

Hi @Anonymous,

Please mark the right/helpful reply as answer. More people will learn new things here and we can close the case.

Thanks,
Angelia

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

After test, your requirement is impossible. You can create an idea here, product team will consider it if many people vote it.

Best Regards,
Angelia

[Anonymous]

Hi guys! I´m building a new report for my boss. This report takes projects titles, amounts, dates, etc from a database.

I had constructed a table which includes the Project Code, Amount and Signer.

I want to know if there is a possibility of adding another table that shows the project description, dates and area WHEN YOU CLICK the project name in the first table I had created.

Thanks for your help!