Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)
I want to create a report in Power Bi and I want drill through from home page by using Feild A to multiple other pages and I am using a dynamic parameters using URL to replicate the Drill effect through functionality and want to check Url for Category X,How can I do it?

1 Answer

0 votes
by (22.5k points)

Dynamic text measures can be used for creating URLs

Which looks like this:

VAR reportURl =
    TRUE (),
    //Are there filters on education and currency?
    AND (
        ISFILTERED ( Customer[English Education] ),
        ISFILTERED ( ‘Currency'[Currency Name] )
    AND (
        ISFILTERED ( SalesTerritory[SalesTerritoryCountry] ),
        ISFILTERED ( ‘Currency'[Currency Name] )
    //define the fallback URL”
) //use a hidden table\column in the model to use the filter to make it easier to add other filters

    & “filter=a/a=1” 

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification      

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers


104k users

Browse Categories