cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teejayst Frequent Visitor
Frequent Visitor

Using Geographical Hierarchy on Multi row card

Hello,

 

I have a few questions on the multi row card and using hierarchy

 

1) Is there a way to incorporate Geographical hierarchy feature on multi row cards?

For e.g. in the below I would like to be able to drill down AMS (Americas) into North America and Latin America

 

2) In my dataset the Worldwide aggregate Units i.e. 7,056 is showing up for AMS and as (Blank) . How do I remove the (Blank)? I don't need the aggregate.

 

3) The Total unit DAX formula used is Total Units = sum('tablename'[Units])/1000 .. I have used this formular across the report (and is working right) but is not working when I use hierarchy in these multiple row cards.

 

 

 

Geographical hierarchy in Multi row cards.PNG

 

 

2 REPLIES 2
Highlighted
v-cherch-msft Super Contributor
Super Contributor

Re: Using Geographical Hierarchy on Multi row card

Hi @teejayst

 

1) Based on my research, it seems there's no better way to incorporate Geographical hierarchy feature on multi-row cards.

https://sqldusty.com/2015/10/14/drill-down-with-power-bi-visualizations/

 

2) You may try to check the aggregation or set the visual level filters.

1.png

 

3) It seems you may need  ALLSELECTED Function for your measure. If it is not your case, please share your data sample file and expected output.You can upload it to OneDrive or Dropbox and post the link here.

 

Regards,

Cherie

 

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
teejayst Frequent Visitor
Frequent Visitor

Re: Using Geographical Hierarchy on Multi row card

Thank you. Let me study the links you sent as well as the AllSelected function and I will get back to you if it does not work.

 

Regards

Tejaswini

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 128 members 1,700 guests
Please welcome our newest community members: