Dynamically Hiding (Replacing) Suppler Names

Hi all,

We have an arcane old spreadsheet that is used to generate visuals for supplier engagement meetings. These visuals are quite specific in that they show the relevant suppler's market share ranked against their anonymised competitors in rank order (see sample visual below).

This is one of a series of similar visuals produced, that are generated and copied into a slide deck for presentation to each supplier.

I have been tasked with building these visuals into a Power BI dashboard that can be filtered with a slicer to quickly and dynamically generate all the visuals in one or two pages. The dashboard will also needs to be filtered by financial year.

I have attempted to modify the method shown in this blog post, however it uses measures to hide the supplier names, which I cannot make display correctly on my visuals.

A sample pbix file with an example of my existing attempt can be found here.

I have attempted to adapt the method to create new columns in my tables instead, but have so far been unsuccessful.

My intent is to create a couple of new columns that do the following:
 - Rank each supplier by market share

 - Concatenate the ranks to make new hidden supplier names "Hidden Supplier [RANK]"

 - Conditionally replace the relevant supplier's name, filtered with a slicer, so their actual name appears in the column instead of "Hidden Supplier [RANK]"

 - Use the new column in the y-axis field of the bar chart visual

I have attempted to use RANKX to rank the suppliers, but can only make it work as a measure, and not output into a column.

I would greatly appreciate any advice on how to achieve the desired visuals, new approaches are welcome.

The dashboard will be for internal use, so only visuals themselves need to be anonymised. The underlying data doesn't need to be hidden.

Thanks