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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

0

Drill Through not working on hidden visuals

In my Power BI report, I have an overview page where I select a drill through to a details page 

oogundipe_1-1700240422746.png

 

 

On the Campaign Details page, I have a chart visual and a matrix visual which are displayed/hidden by using a button click. The first visual that is displayed on the "Campaign Details" page accurately dispays the filtered values

oogundipe_2-1700240547116.png

However when I click the chart button to dynamically show the matrix details, it is filtered wrongly. 

oogundipe_3-1700241219772.png

 

The correct filters are applied to whichever visual that is displayed first on the "Campaign Details" page but not to whichever is hidden.

I am unable to attach the .pbix file, it says file type not supported

Please Help!!!

 

 

Status: Delivered

Hi  @FranciscoCand 

Thanks for your help ! @oogundipe I am so glad that you have fixed your issue , I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi  @oogundipe 

Can you explain "The correct filters are applied to whichever visual that is displayed first on the "Campaign Details" page but not to whichever is hidden." in detail ? Or can you provide a screenshot of the effect you need? 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

oogundipe
Frequent Visitor

Hi @v-yetao1-msft 

I would like it when I toggle between the chart and matrix visuals on the "Campaign Details" page for the filters chosen on the "Overview" page to be maintained.

 

oogundipe_1-1700488862242.png

 

oogundipe_2-1700488908306.png

 

 

oogundipe_0-1700488819090.png

 

 

FranciscoCand
New Member

Hey oogundipe! Check the settings of your bookmark. According to your explanation, the "Data" option should be unpicked. I've tried with your sample and it's working right now (check the gif). 

FranciscoCand_0-1700498550820.png

PBI working.gif

If I helped you please mark it as Solution😉

oogundipe
Frequent Visitor

@FranciscoCand Works perfectly. Thanks so much!

v-yetao1-msft
Community Support
Status changed to: Delivered

Hi  @FranciscoCand 

Thanks for your help ! @oogundipe I am so glad that you have fixed your issue , I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao