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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
aldopelaez
New Member

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

 

aldopelaez_4-1630510983839.png

aldopelaez_5-1630511132726.png

 

The relationships I have are the following

aldopelaez_6-1630511181655.png

Someone could tell me what I need to filter

 

thanks

3 REPLIES 3
v-kkf-msft
Community Support
Community Support

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

v-kkf-msft
Community Support
Community Support

Hi @aldopelaez ,

 

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

 

tempsnipssssf.png

 

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.

MFelix
Super User
Super User

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors