Need help with conditional formatting and rank order

[Anonymous00729]

Hi all,

I'm currently using Power BI version 2.152.1279.0 64-bit (March 2026) and I need some help with something that I'm trying to acheive.

I'm trying to create a similar image to the one below. Please note, the values differ slightly from my actual values because I was sourcing some data viz ideas from Claude...

Currently, I'm using the native table matrix visual within Power BI to create the 1st chart "Theme signal strength overview" and a clustered bar chart for the 2nd chart "Signal strength by descriptor". However, in my screenshoot below, I'm trying to get the standard descriptors (in the red box) to show in ascending order.

I currently have the this calculated column within my table:

Descriptor Rank = 
VAR CurrentScore = 'wine_perception_descriptors'[Log_Odds]
VAR CurrentAlignment = 'wine_perception_descriptors'[Alignment]
VAR CurrentTheme = 'wine_perception_descriptors'[Theme]
RETURN
IF(
    CurrentAlignment = "Premium",
    RANKX(
        FILTER(
            'wine_perception_descriptors',
            'wine_perception_descriptors'[Alignment] = "Premium"
                && 'wine_perception_descriptors'[Theme] = CurrentTheme
        ),
        'wine_perception_descriptors'[Log_Odds],
        CurrentScore,
        DESC,
        DENSE
    ),
    RANKX(
        FILTER(
            'wine_perception_descriptors',
            'wine_perception_descriptors'[Alignment] = "Standard"
                && 'wine_perception_descriptors'[Theme] = CurrentTheme
        ),
        'wine_perception_descriptors'[Log_Odds],
        CurrentScore,
        ASC,
        DENSE
    )
)

My current setup is as follows:

Y-axis: Descriptor, Alignment

X-axis: Avg_Log_Odds

Filter on visual: Descriptor Rank (calcualted column above) with basic filtering set to 1,2,3. (Because I'm showing the top 3 descriptors per theme)

The positive values are fine (purple and black bars, 1 yellow bar). This displays as it should. Please can someone advise on how I can sort the standard-aligned values in ascending order. In other words, I want "everyday" to show first and "delicate" to show last for the standard-aligned descriptors in the red box.

Also if possible, please can someone advise on how I could add a coloured circle icon in the table row headers (as shown in the first image for the 1st chart) so that it improves clarity for the user.

Thank you.

[Anonymous00729]

Hi @lbendlin,

Thank you for responding. Please find 3 links attached.

wine_perception_descriptors.csv

wine_perception_themes.csv

Sample.pbix

These are the files that I used to create the visuals in the sample file attahced (Sample.pbix).

Please may I have assistance with with these two outcomes:

1. Conditional formatting

In my previous message, I described that I was trying to recreate a similar image to the visual that Claude had generated. This make reference to the "Theme signal strength overview" chart. I'm not sure if I'm able to add a coloured circle icon to my table matrix row headers.

I'm looking to achieve something like this, so that it makes referencing the themes in the 2nd visual a little easier...

2. The rank order of my 2nd visual (bar chart) "Signal strength by descriptor"

I'm trying to get the standard descriptors (in the red box) shown in my previous message to show in ascending order.The positive values are fine (purple and black bars, 1 yellow bar). This displays as it should.

Please can you advise on how I can sort the standard-aligned values in ascending order. In other words, I want "everyday" to show first and "delicate" to show last for the standard-aligned descriptors in the red box.

More info on this is in my previous message.

Thank you.

[lbendlin · Accepted solution]

Something like this?

Not sure how the averages are aligned between the two tables - check my "Closest theme"  measure.

[Anonymous00729]

Hi @lbendlin,

Yes, this is perfect. Thank you so much!

For the bar chart, I think I'm going to have to split that chart into 2 separate charts - Premium-aligned descriptors and Standard-aligned descriptors. I don't think it would be possible to have them both on the same chart where one group (positive-aligned descriptors) are arranged in descending order, whilst the other (standard-aligned descriptors) appears to be arranged in ascending order when it dhould be in descending order ( where the most negative value comes first). The middle axis wouldn't accommodate them in the same visual.

But, thank you so much for your time and effort. I greatly appreciate you assisting me with this. For your time and effort, I will mark this as the accepted solution because it solved the first visual's problem. Kudos to you!

Best regards,

Anonymous00729

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...