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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Prarav
Frequent Visitor

Drilldown/not showing correct values

Hello,I am quite new to Power BI and I am encountering the following issues:

I have four tables (A, B, C, and D) that are related as shown in the screenshot below. I need a chart to display the count of signed documents by the main office. Additionally, when drilling down into a main office, the chart should show the count of signed documents by each sub-office.

My issue is that the bar chart displays the correct count of signed documents by the main office (e.g., main office MD shows a count of 100 signed documents). However, when I drill down to view the counts by sub-office, it shows the same value for all sub-offices (e.g., md1: 100, md2: 100, md3: 100). The counts are not displaying correctly for the sub-offices. How do I resolve this issue?

 

Prarav_0-1715972835330.png

 

2 REPLIES 2
v-cgao-msft
Community Support
Community Support

Hi @Prarav ,

Looking at the relationship, TableD's filter can't filter TableB. If the amount of data is small, try changing the direction of the cross-filter between TableC and TableD to both.

vcgaomsft_0-1716170536925.png

Bidirectional cross-filtering in Power BI Desktop - Power BI | Microsoft Learn


Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

I tried changing the direction of the cross-filter between TableC and TableD but still not working. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.