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.
Curves below show running values across many companies.
When trying to filter by company only one of the curves gets filtered as per second snip. In this respect it would take three standalone filters to show per company values.
I've created a relationship on the company column between three curves but it is not working.
The relationship was set as many2many and inactive.
There is another active relationship on dates. The filtering visual though should activate second relationship??
Solved! Go to Solution.
Hi @Mike_Mace ,
Thank you for your so detail relationship picture. We can try to create a calculated table as Dim table
CompanySlicer =
UNION (
ADDCOLUMNS ( DISTINCT ( 'Actuals'[Company] ), "Type", "Actuals" ),
ADDCOLUMNS ( DISTINCT ( 'Recovery'[Company] ), "Type", "Recovery" ),
ADDCOLUMNS ( DISTINCT ( 'Planned'[Company] ), "Type", "Planned" )
)
After create relationship with three fact tables ,then you can put the company column and type column into two slicer(or hieracy slicer).
Best regards,
Hi @Mike_Mace ,
Sorry for that, We cannot understand your data model clearly, Could you please describe the fields of each tables , the relations between tables simply and the field used in the chart?
Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Hi @v-lid-msft,
Thanks for the message. Info below:
1. describe the fields of each tables
There are three sets of deliverables per company. Planned, Actual, Recovery.
I use a DAX to measure the Running values.
Because each set of deliverable uses a different date-set. I use a calendar base date set on the running DAX
DAX:
2. the relations between tables simply
Yellow highlighted is the active relationship between all date sets. Very much needed to be able to plot all curves against one date set.
Blue underlined is my attempt to create another relationship under company
3. the field used in the chart?
The measures for the 3 Running totals are on the chart and a calendar based date set on the X axis.
Since the Scurves are global, filtering down to company level is needed.
Snip below extents view to Fields section.
I used a filter based on Company from Planned table. Filtering on Company 5 filters the planned curve but not the other two which means my attempt to create a relationship on company columns between Planned, Actual, Recovery data was unsuccessful 🙂
Could easily create 3 Filters. One for each Planned, Actual, Recovery company column.
But that would only confuse users
Hi @Mike_Mace ,
Thank you for your so detail relationship picture. We can try to create a calculated table as Dim table
CompanySlicer =
UNION (
ADDCOLUMNS ( DISTINCT ( 'Actuals'[Company] ), "Type", "Actuals" ),
ADDCOLUMNS ( DISTINCT ( 'Recovery'[Company] ), "Type", "Recovery" ),
ADDCOLUMNS ( DISTINCT ( 'Planned'[Company] ), "Type", "Planned" )
)
After create relationship with three fact tables ,then you can put the company column and type column into two slicer(or hieracy slicer).
Best regards,
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |