Forum Discussion
Solved
Month Year Trend Line
In this visualization, the trend line needs to display MONTH AND YEAR...how can I achieve that in Power BI? Right now I only have the months, see screeshot below. I was able to do it in Tableau, see the other screenshot for reference and visual representation of the goal.
- Instead of selecting date hierarchy choose apptime_adj.
Else take duplicate column of your apptime_adj and from Modelling tab change the data format to month-year format from drop down.
Please give Kudos to this effort and mark it as a solution if it helps you.
4 Replies
- Instead of selecting date hierarchy choose apptime_adj.
Else take duplicate column of your apptime_adj and from Modelling tab change the data format to month-year format from drop down.
Please give Kudos to this effort and mark it as a solution if it helps you.Thanks for the reply Tahreem24
Everytime I select apptime_adj, data hierarchy is automatically selected. I can't figure out how to select one without the other.
As you suggested, I duplicated the field in the modeling tab, chose MMMM YYYY format, but the outcome is the same as above. What am I doing wrong?
This was done in DAX and worked, now I am experimenting with Power Query M. Any feedback on how to convert date to MM YYYY in that?
