cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Udit_C
Frequent Visitor

Displaying Data for every N Months (Every 3 Months , Every 12 Months)

The Use Case :

The Slicer has 4 options to select data from :
1. Daily
- Select Start and End Date in the slicer
- Display the data based on the date Selection
Daily_Frequency_1.png

2. Monthly
- Select Start and End Date in the slicer
- Display the data for All Month End Dates between the Range
Monthly_Output_1.png

3. 3 Months
- Select Start and End Date in the slicer
- Display the data for All Month End Dates between the Range
BUT now the difference between the month end dates should be 3 Months and not 1 month.
Quarterly_Output_1.png

4. 12 Months
- Select Start and End Date in the slicer
- Display the data for All Month End Dates between the Range
BUT now the difference between the month end dates Should be 12 Months.
Yearly_output_1.png

For futher reference please find the attached screenshots of different output scenarios


0 REPLIES 0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors