Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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.
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |