Forum Discussion
Date format in visualisation
Hi All, I'm completely new to Power BI and already excited about all the possibilities it can.
I'm trying to find a solution to a simple challenge I have but I don't know what keywords to type to find what I'm looking for.
So, hopefully you can help me out!
At this moment I have a report displaying a date but splitted over 3 columns:
This is not what I want as I'd like to see (and even more important, sort decending so the latest update comes on top) only one column with the whole field as in the Query:
Hope you understand what I'm looking for and you can tell me where to find the solution.
nbr - So making a few assumptions, click on your visual. In the Visualizations pane, find the column or measure for your date. Click on the little arrow to show the drop down. Choose Date or column name instead of the date hierarchy.
Since you are a New Member, Please check out this list of common issue here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
2 Replies
nbr - So making a few assumptions, click on your visual. In the Visualizations pane, find the column or measure for your date. Click on the little arrow to show the drop down. Choose Date or column name instead of the date hierarchy.
Since you are a New Member, Please check out this list of common issue here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Try to concatenate it:
Combine Date Column= Table[Day]&"/"&Table[Month]&"/"&Table[Year]
