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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BishwaR
Helper V
Helper V

Three Parameters

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

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS
FarhanAhmed
Community Champion
Community Champion

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

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

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

View solution in original post

2 REPLIES 2
FarhanAhmed
Community Champion
Community Champion

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

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.