Forum Discussion

ADAM_DUNWORTH's avatar
ADAM_DUNWORTH
Frequent Visitor
3 years ago
Solved

How to Compare Two Selected Values in A Filter

Hi All    Hoping someone can help me with a particularly tough problem  I want to compare the difference between mulptiple selected values in a filter    So if the user selects Date 1 [1st Jan] ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ADAM_DUNWORTH,

Did these two filters used the same table field as source? AFAIK, current power bi does not support to get different value from the same source table field.

You need to create an unconnected table as source for filter2 to get different selections values, then you can use it to compare with the raw filter selections.

Regards,

Xiaoxin Sheng

ADAM_DUNWORTH's avatar
ADAM_DUNWORTH
Frequent Visitor
3 years ago

Yes its all one table. I also tried making two seperate tables where which had a single distinct column for the date column and then tried via that way but the attempt still failed