topic Three Parameters in Report Server

Three Parameters

BishwaR — Fri, 20 May 2022 03:49:15 GMT

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

Re: Three Parameters

FarhanAhmed — Fri, 20 May 2022 10:47:32 GMT

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

Re: Three Parameters

BishwaR — Fri, 20 May 2022 19:35:02 GMT

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