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 ...
- 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.
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.
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?
select the MM YYYY in your Line chart's Axis property. Here you selected Date hierarchy.
