Change the x-axis dynamically

[Anonymous]

hi

i need to dynamically change the axis where i was using below video but in this video i was need to do the duplicate of  table and then do the unpioviting . i am not sure if the values gets changed/added to the main table  will the unpivot table creating will get the  new column inserted?. Is there any way we an achieve the dynamic axis solution .

https://www.youtube.com/watch?v=n-OWNaCUU0o

 else can you propse any other solution please

[v-jiascu-msft]

Hi @Anonymous,

Is this the duplicate of this one: https://community.powerbi.com/t5/Desktop/dyamic-axis-implementation-help-needed/m-p/568072#M268139?

Can you share a sample file and the expected results, please?

Best Regards,
Dale

[Anonymous]

hi @v-jiascu-msft

yes in the below link i shared the sample file and the scliers of the data needed .can you please check

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

I'm afraid there isn't a better solution for now. Because the Axis can't be dynamic for now. There could be a workaround. Please refer to the snapshot below. You can get three levels in one Visual. The Axis will be updated when you go to the next level. They are independent.

Best Regards,
Dale