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
NavaneethaRaju
Helper IV
Helper IV

Selected city have to displayed in drillthrough page

Hi,

I wrote a measure for drillthrough page. and i add card visual. 

 

Filter on all pages i add few columns. like Market, Divison, VP Name.

 

This measure works when i drillthrough with out selecting any filters..

Selected state & country =
IF(
ISFILTERED(Account[Ship Country_Map]),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map])),

IF(
ISFILTERED(Account[Ship State]),
CONCATENATE("State- ",SELECTEDVALUE(Account[Ship State]))
)
)

I dragged above measure in CARD Visual.

 

Figure-1:

 

NavaneethaRaju_0-1643346211160.png

Figure 2-

NavaneethaRaju_1-1643346231735.png


After selecting one of the filter in Divison Field from (Filter on All pages)
Figure 3-

NavaneethaRaju_2-1643346278176.png

Figure 4 -

NavaneethaRaju_3-1643346299227.png

 

I want to display the country name on card Visual.

 

@amitchandak , Please help me this as soon as you can.

 

Thank you.

 

3 REPLIES 3
amitchandak
Super User
Super User

@NavaneethaRaju , the Current one expects one of the two is filtered Ship State , Ship Country_Map

you can add third one for division, use else, or just keep CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map]))

 

or

 

Switch( True() ,
ISFILTERED(Account[Ship Country_Map]) || ISFILTERED(Account[Ship State]),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map])),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map]))
)

 

or

 

 

Switch( True() ,
ISFILTERED(Account[Ship Country_Map]) || ISFILTERED(Account[Ship State]) || ISFILTERED(Account[Divison]),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map])),
CONCATENATE("Country- ",SELECTEDVALUE(Account[Ship Country_Map]))
)

Hi,

 

Actually division id, Divison name that are in separate Division table. we are just using one of the column in that division table in Filters on all pages in page level filter. when they try to filter one of the division name, that time only few states and counties are not displayed in Drillthrough page(Another Page). Ex: malaysia, uk states(Kent, New Hampshire). only few.

Hi @NavaneethaRaju ,

 

Do you have an established relationship between your Account table and Division table?

 

In my test data, the filtered countries/states were successfully drilled through.

 

vkkfmsft_0-1643868174980.png

vkkfmsft_1-1643868202521.png

 

Best Regards,
Winniz

 

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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