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.
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
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.