Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Proud to be a Super User!
Thank you so much. I was referring to Paginated Report and cascading parameters really helped me
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
Proud to be a Super User!
Thank you so much. I was referring to Paginated Report and cascading parameters really helped me
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |