Forum Discussion
Comparing values from last period when date is always different using slicers before and after
Hi Anonymous ,
Looking at your model there is no need to redo your measure. This is a questions about how you setup the table.
I have made the following changes:
- Hide the Date on the Sales Table
- Show the Date on the Date Table
- Used the Date from the Date table instead of the Holidays table
Result below (table on the rigth my table, on the left your table:
Hi Anonymous ,
This has to do with context, since you are making the calculation of the values between the two dates you will never get the values for each date.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi MFelix ,
Here is a sample pbix I modeled after.
If you notice you can adjust the days before and after Thanksgiving, the value changes, which is fine, but now I want to show the dates(and their values) before and after on separate lines.
Thank you!
Mike
Hi Anonymous ,
Looking at your model there is no need to redo your measure. This is a questions about how you setup the table.
I have made the following changes:
- Hide the Date on the Sales Table
- Show the Date on the Date Table
- Used the Date from the Date table instead of the Holidays table
Result below (table on the rigth my table, on the left your table:
Hi MFelix ,
Thank you.
Let's continue with this sample pbix file. My actual Pbix has sensive data, but it is mostly modeled after this one.
What I'm also trying to do is compare the the sales of Thanksgiving Year to year.
So if I cntrl click on the Years and choose more then one year, for example 2011 and 2012, I want to see the sales difference between 2011 and 2012. Furthermore, if I want to change the slicers for a few days before Thanksgiving, and a few days after Thanksgiving, I'd like to see the days and sales differences from 1st year to 2nd year, day by day.
Currently, if I click more then one year, your chart only shows the first year, and on top of that 11-25-2011 is not Thanksgiving (but at this point i'm not too concerned about this yet). I'm more interested in seeing the days before and after Thanksgiving with each value per days before/after.
Thank you,
Mike