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.

Reply
likhithar
Helper III
Helper III

Clearing Month Filter in Drill through Page

Hello All,

I have my Main Page in the Below Format

likhithar_0-1657523064761.png

Fin Year and Month Name fields are from Date Table.

In My Drill Through Page I'm showing Trend Chart for the Selected Row-Column Combination.
For that I created Another Calendar Table where it's not related to any Tables.

likhithar_1-1657523379076.png

Now If Do Drill Through from Main Page,The trend chart is showing value only for selected month in Drill through Page(Ref in The below Snap)

likhithar_2-1657523830213.png

If I clear the Month name Filter ,then it's showing the trend(Which I don't want to do).

likhithar_3-1657524014331.pnglikhithar_4-1657524197078.png

 

Any other alternative for this.

 

TIA

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@likhithar , Based on what I got. You have an option just above drag drill through the field here.  Keep all filters. Uncheck then and then put all those you want to filter below. It will only filter what you have dragged. So, do not put month there

@amitchandak  It will be auto filtered when we do Drillthrough

likhithar_0-1657528301198.png

The Normal Font is Drag and Drop fields,Italic Font is auto filtered from Main Page

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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