cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kmistry98 Helper I
Helper I

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
Microsoft
Microsoft

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

Hi @kmistry98 ,

 

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

Super User I
Super User I

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

Hi @kmistry98 ,

 

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!




kmistry98 Helper I
Helper I

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

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 

Microsoft
Microsoft

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

Hi @kmistry98 ,

 

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

kmistry98 Helper I
Helper I

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

Hi Kelly,

 

I didn't mention 'data steam'? 

Microsoft
Microsoft

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

Hi @kmistry98 

 

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.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors