Forum Discussion
basic table: why is a table displaying Year, Quarter, Month, etc. when I want just the date
I'm just getting started with Power BI and am using a very simple excel worksheet as a source. I clicked on the Table visualization. It's automatically breaking dates down into Year, Quarter, Month, Day. All I want to display is a MM/DD/YYYY date, but I can't figure out how to tweak the table.
Also, the table is automatically adding totals at the bottom. One of the columns is a running total. It doesn't make any sense to total it, but I can't figure out how to turn off the total on that column.
CBahnsen - That's default behavior. In the Visualizations pane, in Values area. Click the down arrow next to MyDate and chose MyDate or Date versus the hierarchy.
Since you are a New Member, you may find these resources helpful Common issues are listed 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.Welcome!
5 Replies
- Greg_Deckler
Community Champion
CBahnsen - That's default behavior. In the Visualizations pane, in Values area. Click the down arrow next to MyDate and chose MyDate or Date versus the hierarchy.
Since you are a New Member, you may find these resources helpful Common issues are listed 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.Welcome!
Thanks for the tip. It took me awhile to figure out how to display in MM/DD/YYYY format but I muddled through.
Greg_Deckler Repost after figuring out how the @username works. Thanks for the tip
- FrankAT
Hi CBahnsen,
- You can deselect year, quarter and month from the hierarchie.
- Take a look at Files > Options and Settings > Options.
- Deselect checkbox Auto date/time for new file (see figur 1).
- Deselect checkbox Auto date/time for the current file (see figure 2.
Enclose the measure for the running totel in an if-statement and use the function HASONEVALUE() like this:
IF( HASONEVALUE(NewCovidPatients),[Your Measure], BLANK())Regards FrankAT
