Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Currently the table shows all the categories, while none are needed until a specific ID is selected in the bar chart.
How to fix this?
1.Details
|| ID | cat1 | cat2 | cat3 ||
1 | technology | Samsung | phone
2 | technology | apple | MacBook
3 | food | beverages | juice
4 | cloth | Zara | shirt
2.Amount
|| ID | Quantity ||
1 | 2
2 | 4
3 | 1
4 | 3
Sample pbix
Solved! Go to Solution.
@Anonymous
I will be voting for the suggested idea, it will be very useful if applied.
Thank you for your efforts, appreciated. I checked the button but it doesn't give me the desired result, instead I used the (ISFILTERED Function) and it worked for me.
I found the posts below very helpful
Table Visualisations blank until something selected in a slicer
Visualisations blank until something selected in a slicer
Hi @SA2 ,
Please test the tooltip to see if it is the function you want.
Using report tooltip pages in Power BI
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
@Anonymous
what if I want my data to be clickable links, using the tooltip will show the links but what if I want to click them, is that possible via tooltip? or is there any other method to achieve that?
check the edited sample below
edited sample pbix
Hi @SA2 ,
Unfortunately, this can't be done with tooltips. Someone came up with a similar idea and you can vote for that idea.
I recommend using the button, please refer to the configuration.
Attach the pbix file for reference.
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
@Anonymous
I will be voting for the suggested idea, it will be very useful if applied.
Thank you for your efforts, appreciated. I checked the button but it doesn't give me the desired result, instead I used the (ISFILTERED Function) and it worked for me.
I found the posts below very helpful
Table Visualisations blank until something selected in a slicer
Visualisations blank until something selected in a slicer
@DataVitalizer
Currently the table has all the categories as in the first picture, but I don’t want them to appear until I select one ID from the bar chart to be reflected in the table by showing only the related categories in the table just like the second picture
User | Count |
---|---|
77 | |
76 | |
44 | |
31 | |
26 |
User | Count |
---|---|
98 | |
89 | |
52 | |
48 | |
46 |