Forum Discussion

aldopelaez's avatar
aldopelaez
New Member
5 years ago

I need help report filter

HI

Hi there. I am trying to filter in all the dashboards by the table "Fecha modificacion" but I can't get the charts to update

 

 

The relationships I have are the following

Someone could tell me what I need to filter

 

thanks

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi aldopelaez ,

     

    Since you are making a one to many relationship you need to use the single side of your relationship to make the axis and the slicer in this case if you use the Column date from the Creation table should work has needed.

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    5 years ago

    Hi aldopelaez ,

     

    Please set the cross-filter direction between crm_powerbi table and Creacion Cierre table to "Both".

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi aldopelaez ,

     

    Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Winniz