cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
spandy34
Post Patron
Post Patron

Card Visual Drill not working

 

I have a card visual that is based on a measure.   I have a drill report that when I right click it takes me to a summary report.  There are 241 records but when I got to the drill report all records appear.  How do I get the drill report to display 241 records? 

 

spandy34_2-1677244269135.png

 

In the report I have the measure listed in the Drill Though fields list and have Cross Report and Keep All Filters set to on.

spandy34_3-1677244289033.png

 

Is there a setting I am missing on the actual card visual?  Any ideas what I am doing wrong?

@amitchandak @tamerj1 @danextian @goncalogeraldes 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@spandy34 , if the card is using a measure that is filtering the record/data. make sure that visual is used in drill-through report.

 

You can also use the measure as visual level filter

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@spandy34 , if the card is using a measure that is filtering the record/data. make sure that visual is used in drill-through report.

 

You can also use the measure as visual level filter

The measure on the card is

z_NorthStar_Prop = calculate(counta ('Main Data Table'[UPRN]),'Main Data Table'[Landlord Name] = "North star")

 

The settings on the card visual is below also

 

spandy34_0-1677249318356.png

 

spandy34_1-1677249318357.png

 

Is that correct?  I also have the z_NorthStar_Prop measure in the drill down report drill down fields

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors