Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
SA2
Frequent Visitor

How to show attributes only when single record is selected?

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

Links1.pngLinks2.png
Sample pbix 

1 ACCEPTED 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 

View solution in original post

6 REPLIES 6
v-cgao-msft
Community Support
Community Support

Hi @SA2 ,

 

Please test the tooltip to see if it is the function you want.

vcgaomsft_0-1651126905360.png

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?
links tooltip.png
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.

Microsoft Idea

 

I recommend using the button, please refer to the configuration.

vcgaomsft_0-1651217963390.png

vcgaomsft_1-1651218034298.png

vcgaomsft_2-1651218088997.png

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
Super User
Super User

@SA2 

Could you explain more your need or the desired result?

 

 

@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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.