Dynamic Axis Relabelling

[doubleclick]

HI all, 

Super difficult problem. 
I'm building a supplier scorecard, the supplier is the user. I need to show the their data whilst anonymising the other suppliers into Supplier1, Supplier 2, etc. 

I need to use this in a graph, so imagine there's the supplier spend on the Y, supplier name on the X, but the supplier name needs to be dynamic so it only shows the name of the selected supplier (via RLS but for now via a slicer) and for others it anonymises them by saying Supplier 2, Supplier 3, etc 

I've managed it on a row level context using a parameter, and can use that in a table, with some limitations, how can this be achieved???

[V-yubandi-msft]

Hi @doubleclick ,

We have not yet received any updates. Please let us know if you require any additional clarification or details from our side.

Thank you.

[V-yubandi-msft]

Could you please confirm whether your issue has been resolved or if you’re still experiencing any difficulties?

Your update would be helpful for the community and may assist others facing a similar issue.

[kushanNa]

Hi @doubleclick 

are you looking for an output similar to this ?

if this is what you are looking for then , i have attached the sample i have created for your reference 

[doubleclick]

Yes this!!!! thank you! How did you do this???

[V-yubandi-msft]

This approach uses a mapping table (Index → Name) linked to the main data. The visual uses that for the axis instead of SELECTEDVALUE, so it handles multiple selections properly.

Thank You.

[doubleclick]

but you have to createa a parameter table specifically for this to work, and that parameter table has to include the measure information inside it?

[V-yubandi-msft]

No, a parameter table isn’t necessary for this. Parameter tables are typically used for switching measures, but it’s not needed here.

For your situation, you only need a column with the labels use the real name for the selected supplier and (Supplier 1, 2…) for the others and place that on the X-axis.

This makes the setup much simpler, as there’s no need for a parameter table.

I hope this helps clarify things.

[kushanNa]

@doubleclick 

The concept is similar to this tutorial: https://www.youtube.com/watch?v=lFd2hjkKz_Q

However, I used DAX to create the tables. You need a table with a selection for each name, as well as anonymous entries like User1 and User2. Then group them using an index so that when you select a name from the index column, you only see the corresponding values.

For coloring, I used the color function and a bar color measure. Based on the selected name, it colors the bars accordingly.

[doubleclick]

is it possible to use a measure instead of summing the parameter table? 
there's a lot of suppliers (5000+), running month data over 3 years

[kushanNa]

Hi @doubleclick 

You mentioned, "I've managed it at a row-level context using a parameter and can use that in a table, with some limitations."
Would it be possible for you to share a sample file via a OneDrive or Google Drive link showing what you have achieved so far at the table level?
That would help me better understand your expectations and convert it into a chart.
Or If you can provide some screenshots of your existing table solution, including the parameter tables and measures code, that would be helpful as well.

[DanieleUgoCopp]

Hello,

I’m not completely sure, but I think to build a separate dimension table for suppliers with the anonymised label precomputed, then use that on the axis and control visibility with measures

Best regards,
Daniele

[doubleclick]

Not sure what you mean? Keep in mind there's about 5000 suppliers 

[DanieleUgoCopp]

the idea is you can’t make the X-axis itself truly dynamic with a measure, especially with 5000 suppliers, Power BI wants a physical column there what I meant is instead of trying to rename on the fly, you precompute something stable like a rank per supplier (for example by total spend), then use that rank to generate labels, so your logic becomes “if this is the selected supplier show real name, otherwise show Supplier + rank”,
with 5000 suppliers you really don’t want to do this purely in measures, it’ll get slow and unpredictable, so better to create a helper table (or calculated column) that already contains SupplierID, Rank, and a default label like “Supplier 1, Supplier 2”, then your measure only swaps the label for the selected one

Best regards,
Daniele

[doubleclick]

I don't understand, how does this allow me to use this on a graph?

[doubleclick]

please could you elaborate a bit further, i put your reponse through gpt but i don't think it fully understood. 

i can't use any measure in teh x axis of a bar chart? this is hard rule. Not sure if that's where you're going with this?

[V-yubandi-msft]

Hi @doubleclick ,

That's a good question. The key point is that Power BI doesn’t support measures on the X-axis, only columns. Instead of renaming items dynamically with a measure, you should create a column that includes the labels you want.

For instance, the selected supplier would display the actual name, while others would be labeled as Supplier 1, Supplier 2, and so on. You can then use this column in your chart. The axis itself isn’t dynamic rather, the column is structured to provide the desired result.

Please review and let me know if this aligns with your expectations.