Three Parameters

[BishwaR]

I have three parameters Invoice Number, City and Country.

When I select a value in Invoice Number how can I automatically get the related City and Country picked up in other 2 parameters ?

Invoice Number is a distinct value but the other two parameters do not have the distinct values.

For example:

Invoice Number     City          Country

 001                        Dallas        USA

 002                        London      UK

 003                        Dallas        USA

 004                        London      UK

So when I select Invoice Number 001 it should pick up automatically City = Dallas and Country = USA

Is it even possible ?

Thank you

[FarhanAhmed · Accepted solution]

Are you talking about Power BI Paginated Reports  or Power BI Reports ?

In case of Power BI Reports,

- if you are using the Filters from same table it will automatically update/filtered on next level

- in case if you have 3 different dimension connected to Fact table then you need to create a measure in fact table i.,e. COUNTROWS(FactTable) and filter the other 2 visuals based the measure.

Types of filters in Power BI reports - Power BI | Microsoft Docs

If you are using Paginated Report

- you need to update your next filter query by passing value from previous parameters.

Create parameters for paginated reports in the Power BI service - Power BI | Microsoft Docs

Use cascading parameters in paginated reports - Power BI | Microsoft Docs

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

[FarhanAhmed · Accepted solution]

Are you talking about Power BI Paginated Reports  or Power BI Reports ?

In case of Power BI Reports,

- if you are using the Filters from same table it will automatically update/filtered on next level

- in case if you have 3 different dimension connected to Fact table then you need to create a measure in fact table i.,e. COUNTROWS(FactTable) and filter the other 2 visuals based the measure.

Types of filters in Power BI reports - Power BI | Microsoft Docs

If you are using Paginated Report

- you need to update your next filter query by passing value from previous parameters.

Create parameters for paginated reports in the Power BI service - Power BI | Microsoft Docs

Use cascading parameters in paginated reports - Power BI | Microsoft Docs

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

[BishwaR · Accepted solution]

Thank you so much. I was referring to Paginated Report and cascading parameters really helped me