Absolutely brutal logical explanation. Very good Chandeep!! Excellent resolution.

Thanks a lot man just what I needed

Best Bi teacher ! Really man

You're a genious, Chandeep! Awesome solution!

I am unable to understand filter context and row context But your video helped me to easily understand Thanks Can you do a video on expanded table

Great one chandeep ...... Will try to use this trick soon 👍

Can you share a video on selecting the 2nd greatest average value in a table using dax

awesome. i will put it to use str8 away

Absolutely magical. Great Chandeep

Could you create a session talk about how to formulate specific rows in a table or matrix? the challenges for me is I am trying to apply what-if for only selected rows in a table(not all rows). thanks in advance!

that is very nice Chandeep! Well done! Bahut shurkiya man!

Nice one Chandeep.. can you please also do some videos on RLS

Strictly even....== ....first time I ever see this....very nice!

Yes its pretty awesome

Hi, TThis is awesome.I have followed the same steps as you did,but I am unable to achieve the conditional formating on multiple selections,could you please help me out?

How to apply conditional formatting for the rows of a matrix visual in power bi

This was neat. Definitely useful trick

Great video. In a similar way, can do conditional formatting based on search text used in a "Text filter" visual. I tried using CONTAINSSTRING function, but was unable to pass user input data as the "find text. Any idea is appreciated.

Hi Chandeep, This is awesome. However, what if, I need to use filter interaction for other visuals at the same time on the same page? :))

Awesome Sir

thank you very much and big shoutout. I am able to get only one value highlighted.

Very nice and Informative Video. Thank you

Awesome, Can you please showcase, how to do for the same color highlight for COLUMN WISE ( eg : Highlight only the current month column ) in MATRIX table???? please

Why don't just check a selected product? IF( SELECTEDVALUE(Products[Product]) = SELECTEDVALUE('Pseudo Prod Table'[Product]), "red")

Can we use edit interactions to stop the filter from interacting with slicer and in conditional formatting use the selected value or some other function and to capture the values in the slicer and highlight the rows ?

The conditional Formatting only works with Table and not with Matrix?

👍. In a Table visual this is possible. Similarly is there any way for the matrix visual for the row items.

Hi Chandeep, My question is not exactly about highlighting rows but I thought of posting here since my question involves selecting/filtering rows of a table visual. I have a quarter slicer (YYYY-QQ) where I select a single quarter, for example, 2022-Q3. Then I have a table that by default only shows me 2022-Q3 data. What I want is to display not just the selected quarter but also the succeeding 4 quarters. For this example, when I select 2022-Q3 in the slicer, I want the table to display all data from 2022-Q3 up to 2023-Q3 (or effectively, 7/1/2022 to 9/30/2023). How do I do this? Any guidance and ideas will be greatly appreciated. Thanks in advance!

How would this formula be adapted on a matrix that has 12 months of the year as column headers?

Great. if there are mutilpe columns to be highlighed. will this logic will implemented. If yes. share some understanding, secondly, if we have text fields instead of int data type the how to use treatas function

You are magical

That's great sir .....

9:12 So why does it highlight all values when nothing is selected ,to begin with?

The highlighted value is getting displayed in all the rows,could please help me

Amazing

👏👏👏

great tips, however beware using the calculated table for large volumes of rows (million). the dataset will take massive hit in queries. supposedly the calculated tables are stored differently to raw fact tables. cheers

🎉🎉🎉🎉😮

What happens when the table has more rows and it has a scroll bar and you select a product which is at the bottom of the table?