CODEWITHSUNDEEP
powerbi
DAXux
DAXux

Reputation: 3

Line Graph in Power BI

Two-line graph with slicers: Everything looks fine until date selections are made.

I figure that this failure has something to do with the line graph and date functionality. Date selections work together in a very weird way. Selecting only 2019 months and then only 2020 months, both lines disappear.

If the date slicers are going to work together, I should expect inclusive behavior, rather than "NOT 2020 AND NOT 2019"!

See relationships.

How do I get the behavior intended on one two-line graph?

Thanks!

Upvotes: 0

Views: 167

Answers (1)

Gigga
Gigga

Reputation: 577

I agree with @teylyn, sometimes less is more.

The problem is how Power Bi works and how your measures are calculated. You have two averagex-measures, both pointing to same date table. In Power BI, two separate filters from a single dimension can't do "union", they are laid down on top of each other. You are telling that first I want to filter by 2019 November and after the filter has been evaluated, you tell that you want to filter 2020 January. Power BI adds new filter to already filtered dataset, but the dataset doesn't contain anything that match both filters, so the end result is empty.

One way to get around this problem is to create separate date-tables for filtering purposes for blue and green. Here is an example of the data model needed: example data model Then you update the date-filters in second tab. Set blue date filter to one date-dimension and green date filter to another. This way they aren't filtering the same table and the graph should work the same as before.

Upvotes: 1

Related Questions