Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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.

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.