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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Is it possible to highlight a row in a table upon clicking on it?

Hi, I'm trying to highlight a row using conditional formatting. So far i've got the following dax:

IF(HASONEFILTER(Flex_Street_20190823[Broker]),"green","white")
 
But that doesn't change the colour of the column if I select it. I've also tried HASONEVALUE but no luck.
6 REPLIES 6
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

I’m a little confused about “data steam ”you said, do you mean “dataflow” or “dataset”?

If it is “dataflow”,  you need to check the credential, steps are as below:

1.Turn to the menu bar,  click “Home”->”edit queries’’->”data source settings”, then find “Global Permissions”-> ”clear permissions”:

1111.png222.jpg

 

2.Then “Get Data” from “Power BI datasets”, you will find a “sign in ”window->”Sign in”:

 

444.png

 

Pls note that “dataflow ” is associated with “credentials ”,be sure that you are using a correct credential.

 

If it’s a “dataset ”issue, pls let me know, I’ ll check and find a solution.

 

Hope this would help.

 

Best Regards,

Kelly

Anonymous
Not applicable

Hi Kelly,

 

I didn't mention 'data steam'? 

Hi @Anonymous 

 

Sorry for the mistake, due to a network confliction, the reply is meant to be  written for another post,so pls ignore it,

 

Sorry again.

AiolosZhao
Memorable Member
Memorable Member

Hi @Anonymous ,

 

Do you mean the below one?

Is it possible to highlight a row in a table upon clicking on it 2.PNGIs it possible to highlight a row in a table upon clicking on it.PNG

 

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Hi AiolosZhao,

 

Similair, but instead of using a slicer, I'd like to click B in the 2nd table and for it to be red while still showing the other options as greyed out. 

 

Thanks 

v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

Based on my test, I am afraid you could not achieve this feature currently, I suggest you submit an idea in Ideas forum.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

 

Best Regards,

Kelly

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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