Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JvdSH
Frequent Visitor

Need help on setting date filter for plan and actual data

Hi guys. I need your help. I have a data for plan actual amounts. Plan data is available for the whole year but actual is until March. I created the chart and when all months selected it shows as below:

pic all.png

 

 

However, when I selected only specific month lets say February. It shows data only for February:

pic as is.png

 

 

But what I need is when month selected it should show bars within that year till selected month and plan for the whole year as below:

pic wanted.png

 

Please share your ideas or suggestions.
Many Thanks

1 ACCEPTED SOLUTION

Screenshot 2024-04-20 at 6.20.51 PM.png

@JvdSH 

Please find the solution in the pbix file:

https://drive.google.com/file/d/18Yhqvq_vErSXZqE4jo5dCek429MnOhLw/view?usp=share_link

 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun

 

View solution in original post

6 REPLIES 6
JvdSH
Frequent Visitor

Works! Thank you

tharunkumarRTK
Solution Sage
Solution Sage

@JvdSH 

Create a disconected date table and replace the fileds in the year and month slicers with the fields from diconnected date table. And the visual will not react to the selections in the slicer. Now modify your measures as per your requirement. For example, for actual your follow a pattern like below

 

 

ActualMeasure = IF(MAX('Calendar'[Date]) <= MAX(CalendarDisconnected[Date]), SUM(Main[actual])) 

 

 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun

 

Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Ashish_Mathur please find the link: actual_plan

Many Thanks

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1713657592853.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Screenshot 2024-04-20 at 6.20.51 PM.png

@JvdSH 

Please find the solution in the pbix file:

https://drive.google.com/file/d/18Yhqvq_vErSXZqE4jo5dCek429MnOhLw/view?usp=share_link

 


If the post helps please give a thumbs up


If it solves your issue, please accept it as the solution to help the other members find it more quickly.


Tharun

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.