Filter column based on another column value

[Anonymous]

Hi every one,

I need help from experts in power bi as i'm new into it.

I have 3 columns: Date, budget 1 and budget forcast. That's is the reason why the values of  the date column go until 2070 but forcast ends up in 2030.
I'm trying do to a histogram since the start date (2001) till (2030). Can someone help me to figure out the dax code?

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @Anonymous ,

In your visual, have you selected Show items with no data in the date column?

If you choose, please cancel it, and the ones with no value from 2030 to 2070 will disappear.

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.

[Greg_Deckler]

@Anonymous Can you not just filter the visual for 2030 or less? Otherwise, if you return BLANK for your measures the extra dates shouldn't show up.

[Anonymous]

Thanks for the idea. It is possioble to it that way but I'm not sure if the client will be satisfied with that option. That's why I was hoping that there's a way to resolve it by a dax code.