Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
@v-cgao-msft
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
@v-cgao-msft
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
@v-cgao-msft
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
112 | |
105 | |
94 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |