Using dynamic URL to link to Drillthrough pages within the same report in Power BI

Question

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?

Answer 1

Dynamic text measures can be used for creating URLs

Which looks like this:

VAR reportURl =
SWITCH (
    TRUE (),
    //Are there filters on education and currency?
    AND (
        ISFILTERED ( Customer[English Education] ),
        ISFILTERED ( ‘Currency'[Currency Name] )
    ), “https://app.powerbi.com/groups/a4969cce-a7ed-4868-82c9-0c8901ab83c2/reports/5g4tc42d-ec49-472c-a34f-3491ebdf4321/ReportSection1?”,
    AND (
        ISFILTERED ( SalesTerritory[SalesTerritoryCountry] ),
        ISFILTERED ( ‘Currency'[Currency Name] )
    ), “https://app.powerbi.com/groups/a4969cce-a7ed-4868-82c9-0c8901ab83c2/reports/7c48c42d-ec49-472c-a34f-3491ebdf6543/ReportSection1?”,
    //define the fallback URL 
    “https://app.powerbi.com/groups/a4969cce-a7ed-4868-82c9-0c8901ab83c2/reports/8r65c42d-ec49-472c-a34f-3491ebdf7564/ReportSection1?”
) //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