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
Anonymous
Not applicable

Card visual drillthrough - Variable -Related Table

Hello  community.

 

I have the following issue. I want to create drillthrough on a card visual and get information from a related table.

 

So i noticed the below : 

When  I use a simple custom variable ( example : customers = DISTINCTCOUNT(myvariable)  ) , adding this on the drill through variables on the drill through page ,everything works fine. Please keep in mind that both, card and drill through page, are generated by the same table.

 
 Example : 
theotria_12-1657202499185.png

 

Drill through page :

Before Drillthrough :

theotria_13-1657202553335.png

 

 After Drillthrough 
theotria_14-1657202590512.png

 

 
Without the custom variable drill through is not working.
 
 
So now i want to do something similar. i use the same approach  but on the drill through page i use a related table.
 
Please check the details: 
variable : 
#Customers_RC = DISTINCTCOUNT(Customers_without_Risk_category[KNB1_Customer_ID])
 
graphs : pie and card 
 
theotria_0-1657200006366.png

 

theotria_1-1657200026721.png

 

 

relation 

theotria_2-1657200277922.png

 

theotria_4-1657201057552.png

 


Drillthrough fields :

theotria_5-1657201125711.png

 

So when i use the pie's drill through, filtering works fine, i suppose block_by_credit field did all the work

theotria_10-1657202090310.png

 


 

result in drill through page / related table :

theotria_11-1657202157803.png

 


 

 

When i use the card's drill through 

 

theotria_8-1657201468208.png

Filtering is not working at all. 

 

theotria_9-1657201614694.png

 

Could you please help me ?

 

2 REPLIES 2
Anonymous
Not applicable

Dear @PowerBI  and @v-yangliu-msft ,I will try  again to make it clear with more printscreens

 

I have 3 tables, two with just one column and a detailed one

theotria_0-1658312971976.png

Both connections ara many to many with cross filter direction = both 

theotria_1-1658313025256.png

 

theotria_2-1658313051387.png

 

theotria_3-1658313078416.png

 

I created two different cards for each one column for each table.

 

theotria_9-1658313843208.png

 

theotria_10-1658313915896.png

 

for both tables a created a custom measure (i read that this is the only way to have a drillthrough option when you use "card")

 

theotria_4-1658313193538.png

 

 

theotria_7-1658313279582.png

 

theotria_11-1658313963223.png

 

In the detailed table i dragged and dropped all those measures , even the variables

theotria_12-1658313993487.png

 

 

So when i use the drill through option for both cards the detailed table is not responding/No filtering

So could you please tell me what i am doing wrong.

 

  • The 2 tables have a many to many connection with the detailed one (filter = both) (i read this on a topic for related table - drill through)
  • I created a custom measure to enable the drill through for the card visual  (i read this on a topic drillthrough for cards)
  • I dragged and dropped all the measures - even the variables i use on my measures - in the drillthrough box
  • The reporting table is not responding.

 

v-yangliu-msft
Community Support
Community Support

Hi  @Anonymous ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.