Forum Discussion
Dynamic Axis Relabelling
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
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.
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
Yes this!!!! thank you! How did you do this???
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.
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
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.
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?
