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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.