Forum Discussion
Mismatch between visuals looking at same data
- Anonymous1 year ago
Hi dthompsonKairos ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!
I tried to recreate it on my end with the sample data and it worked well for me. Here are a few steps to help troubleshoot why November and February are not reflecting the expected values in the card:- If the X-axis is using a text-based field (Month) and not sorted by date, Power BI might aggregate values unexpectedly.
- Multiple Novembers in different years or for different categories may cause average aggregation instead of exact selection. Check if the card is set to Average.
- Check Visual Interactions to ensure cross-filtering is enabled.
Please refer the screenshot and file for your reference:
I hope this helps.If this answer resolve your query,give us kudos and consider accepting it as solution.
Regards,
Pallavi.
Hi dthompsonKairos ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!
I tried to recreate it on my end with the sample data and it worked well for me. Here are a few steps to help troubleshoot why November and February are not reflecting the expected values in the card:
- If the X-axis is using a text-based field (Month) and not sorted by date, Power BI might aggregate values unexpectedly.
- Multiple Novembers in different years or for different categories may cause average aggregation instead of exact selection. Check if the card is set to Average.
- Check Visual Interactions to ensure cross-filtering is enabled.
Please refer the screenshot and file for your reference:
I hope this helps.If this answer resolve your query,give us kudos and consider accepting it as solution.
Regards,
Pallavi.