Forum Discussion
Static data is being assigned a date when plotted on a Line chart due to indirect relationship
I have a table of static data that I am trying to plot on a line chart as a straight line.
When this static data table has no relationships, I am able to do this fine. However, as I need to be able to filter from the total down various levels, I need to create a relationship. When a relationship is created, it becomes indirectly associated with date information and when this happens, the static data turns from a straight line across all dates to belonging to a specific point in time.
Is there a way to keep the relationship to allow for filtering, but stop it being associated with the dates? i.e. presenting as the same value regardless of the date?
4 Replies
- Kaviraj11
Solution Sage
Once you have an Inactive relationship. you can create a measure including the inactive relationship -
Example
Orders Shipped = CALCULATE( COUNTROWS(Sales) ,USERELATIONSHIP('Date'[Date], Sales[ShipDate]) )
Active vs inactive relationship guidance - Power BI | Microsoft Learn
Thanks for the response! Definitely an improvement, although it is now only returning the static line for dates up until the current date. Not sure how to get it to bypass date considerations altogether?
- Kaviraj11
You can try edit interaction.
Change how visuals interact in a report - Power BI | Microsoft Learn
Thanks again for the response, unfortunately the static data is not standalone on the chart and will also be used as the base for a measure, so this does't work for this scenario.
