Visual with grouped hierarchies without repeating common x-axis values.

[Anonymous]

In the example visual 1 this is the format I want to have: Only one instance of "year" and no repeating year-values in the x-axis. This is how it looked when I used automatic time intelligence. However, when I turned auto time intelligence off to use my own calendar table, it does not seem to work anymore. I cannot find a setting to make it work similarly.

As you can see, there is also something wrong with my measures since it's displaying the same value, but it should not affect this at this point. Also don't mind that the calendar quarter and month are in a different format. 

Thanks!

[Anonymous]

Hi @Anonymous ,

Based on my test, if you have customed a new date hierarchy, please firstly sort the visual by it not by Value and then disable "concatenate values" option

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Switching off auto date/time is absolutely the right thing to do. It also means that you now need to provide your own hierarchies. Add the year column from your calendar table into the x axis well of the visual and then disable "concatenate values"

[Anonymous]

I have added the year, qrt and month columns to a hierarchy.  However, I cannot find the setting "concatenate values".

[lbendlin · Accepted solution]