Forum Discussion
Legend Issues when filtering using Start and End Dates
Super UserAsk yourself: Can I get there from here? for all the fields in your visual. The arrows will tell you if you can or not. For example you cannot (and should not) control the Financial Data table from the Events table. The arrows are pointing in the "wrong" direction. You can control both fact tables from the calendar table. For some reason you decided to also control the calendar from the Financial data, which means you can control the Events from the Financial Data. This may not be what you want though.
If you want to use data from disconnected tables you can use measures, and/or TREATAS for filter transfer.
Thank you, this is very helpful for understanding the relationships I am making between the tables. I'm still not sure on how to solve for what I am trying to produce though. For the line graph, I am trying to get it to show two lines (one for each event) rather than just the sum of the two events. The events have overlapping date ranges, which I think is the issue at heart. It's also a bit confusing because I can show this in a table visual, but not in a line chart. Appreciate your help.
- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523