Forum Discussion
Visualisation Advice
Hey
I found out for myself. I needed to create a column to sort by "yyyy mm"
Then it all worked!
Anonymous you can use combo chart where actuals can be on the bar and target as line chart, and measure for actuals and target will be
Actuals = COUNT ( Table[Incidents] )
Target = [Actuals] * 6
I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hey thanks for that ! I like that idea.
Now that I have applied it I cannot get it to behave properly!
This is my very basic date table
This is the outcome if I apply dd/mm/yyyy date to the X axis. It is correct but I dont want it day by day.
This is the outcome if I do it by month name... but I cannot get it to go in proper month order??
This is the outcome with month number. Strangely it adds a "0" which I dont want and alternates labels??
Also as an aside I would like it to display 13 months as we often review things as 13MMA.
Thanks!
Hi Anonymous ,
You could add a rule in filter pane to make result show value which is not blank.
Hey
I found out for myself. I needed to create a column to sort by "yyyy mm"
Then it all worked!
