Slicer - Prior period file date set by current period in slicer

[AndrewB1]

Hello,

I have a visualization table that is filtered by a slicer using the File Date column in my data set. The file date is in month and year format. The slicer is used to detail the number of risks by severity (High, Medium, Low) in a specfic period, eg October 2023. 

I created a second visualization table that shows the same information, but for the prior period. I currently use a second slicer, targetted to this table only, that is manually set to the prior period eg September 2023. 

Is it possible for the first slicer (current file date) to control the prior period slicer? I have already added a coulmn in the data that calculates the prior period, based off of the current file date. The issue with using this column in a slicer is that if a risk has been removed in the period (eg risk DEF456), then it wouldnt show that issue when filtered for September (its not in the October dataset, see below) 

Risk ID	Rating	Current File Date	Prior File Date
ABC123	Moderate	September 2023	August 2023
DEF456	Moderate	September 2023	August 2023
ABC123	Moderate	October 2023	September 2023

Any help would be much appreciated. 

Thanks!

Andrew

[v-stephen-msft]

Hi @AndrewB1 ,

You can try to tick "Show items with no data.

Or you can try creating a calendar.

Creating Calendar Table in Power BI using DAX Functions - RADACAD

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[lbendlin]

You need to add a date column to your data model, and then use EDATE(-1)

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...