Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello. Any help would be appreciated. 🙂
I'm setting a column to reflect dates as:
Data Type: Date
Format: March 2001 (MMMM yyyy)
Within the Table is shows the Data as above.
My issue is the visual is just a veneer, as if I use the drop down filter I can still see the value as DD/MM/YY.
So when I try to plot this as a visual I'm getting plot points for DD/MM/YY and not the MMMM yyyy.
any suggestions please?
Thanks
@c0nners on formatting pagen, change x - axis to categorical as shown below
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks for responding, but that didn't quite do it.
I have data for Jan 2018 and Jan 2019. I can get the LineChart to look the way I'd want it using "Date Hierarchy", if I deselect year and quarter.. however it's going to group all January's in one column. I need a column for to be MMMM YYY.
Ta