Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |