My PBI file :-
Solved! Go to Solution.
You can do it by using the in-built conditional formatting.
Click on the table > on right hand side select 'Format' section > Conditional formatting > then go through all the columns, applying Background color to them based on the Index value
And the result should be the one you want
@Rigensis I manage to only highlight index column when i using your approach that is build in feature.
firstly i select Category
Then i enter number = 14
it does not work. where go wrong ?
You have to do it for every column, just like with the other option, but you do not have to do it row by row. Just specify, which indexes to highlight, and all rows with those indexes will be highligted in the respective column.
In general for every option that goes through conditional formatting section, you will have to repeat the same logic for each column.
I just sometimes find it easier to work without the calculated measures as for large datasets they may make the whole dataset slightly slower, and they are harder to read for others, if someone else wants to work on the same file down the line.
Thank you very much , this approach have one great benefit , that is i can go in to add more row to be highlighted.
Thank you for sharing.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.