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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sshah2
Regular Visitor

how to not show repetition of values?

Repetition values.PNG

 

Hello Community, This is my first post. So please guide me to the right post if it is repeated by any chance. 

Please see the screenshot above. My objective is not to have those repeated values. 

Is it possible to achieve that? If so, can you please guide me in the right direction?

If possible, can you please explain to me why we are getting these repeated values?

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

It looks like a granularity mismatch. Here's a highly relevant article on the topic:

https://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/

(Pay particular attention to the IsBudgetValid measure.)

 

View solution in original post

3 REPLIES 3
AlexisOlson
Super User
Super User

It looks like a granularity mismatch. Here's a highly relevant article on the topic:

https://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/

(Pay particular attention to the IsBudgetValid measure.)

 

Thank you very much Alexis. 

Huge help mate. 

If you don't mind further my query then I will like to ask you the following question:

As a practitioner of Project management, I have to do regular forecasts of various resources. I have thought about doing it in Excel and bringing it into Power BI for reporting purposes. But it will be great if I can do it within Power BI. If you or any community member have a good resource for me to refer to then please share it with me. It will be highly helpful. 

The DAX Patterns linked in that article discuss forecasts:
https://www.daxpatterns.com/budget/

 

Beyond that, I don't have specific recommendations and I'm sure your web searching would be at least as good as mine given your knowledge of your own situation.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.