Forum Discussion
dynamic x-axis based on filter
Hi alops194
are you looking for a solution similar to this ?
you can follow this tutorial to get a dynamic x axis https://www.youtube.com/watch?v=hilfglpKNRQ
I have attached a sample I created so you can play around with it and get it working as needed.
Thanks a lot, I'm close to the solution. I created the measure as you told me. I just changed 0 and 1 based on my parameters fields. The only thing I need to fix is that when I filter the week, the change on the x-axis occurs correctly, but the label it displays is concatenated "month-year week-year" and this can also be seen from the graph title. How can I fix this?
I think the easiest way to fix the x-axis would be to turn the x-axis title off, and you should be able to edit the chart title manually.
Worth noting that when I've used this technique in the past I applied the Top N filter directly on the parameter rather than on the parameter order. I don't think that would make a difference, but it could be worth trying.
Yes, the solution is simple on the title, the problem is on the value in this I would like to only display the week year and not the concatenation with the month