Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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:
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.
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...
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
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
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!
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |