Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter column based on another column value

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?

 

Interesting Links
Need Help
Show and Tell
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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