How to hide first day's data in a column chart without losing the date placeholder.

[Anonymous]

I have a column chart showing day-to-day changes for the last 7 days.  The first column should be just a date on the x-axis without any data in the column, since we don't want to consider data from 8 days ago.  

[Anonymous · Accepted solution]

Hi @Anonymous ,

You need to create two measures.

measure1 = IF([date] >= today()-7,1,0)

Add this measure to visual filter to filter last 8 days' date.

measure2 = IF([date] >= today()-6,[calculated value],0)

Add this measure to value field to show last 7 days' data and show the data of day 8 as 0.

Best Regards,

Jay

[Anonymous]

Thank you, I apparently don't have the ability to post a file attachment here.  We have put the file in Teams.  I hope this works.  https://schoolcraftcollege-my.sharepoint.com/:u:/g/personal/bschreib_schoolcraft_edu/EdKbOaBu1mpMoxj... 

[vanessafvg]

you might need to provide more information.  what is the measure are you showing for the day to day changes, you will probably need to do an measure =  if(isnull(measure),0, measure) if you are wanting a 0 value for that day.  

[Anonymous]

This is the measure: 

Seats Gain Loss = [Total Enrolled] - [Yesterday Enrolled].

Total Enrolled comes from a column and Yesterday Enrolled is another measure that I wrote like this: 

Yesterday Enrolled = CALCULATE(SUM('DataTable'[Enrolled]), PREVIOUSDAY('DataTable'[Add Date])).

Then I put a filter on the chart so that it would return only days > 7 days ago.

[vanessafvg]

Ok then I am not quiet clear what you need.   Please can you share the visual you are using right now and what it is you want differently?