Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Power BI Community !
I am trying to do something that is supposed to be very simple but I can't manage to do it.
I have a slicer that call a column ('Facts'[Company]) with 5 values (AAPL, MSFT, FB, AMZN, GOOG)
When one of theses values is selected, I want another column ('Facts'[Company Flag], which has same values, to be filtered according to the filtered value.
I think It should be a Dax formula with SelectedValue and Switch/IF, but I am not sure how to do it. can you help me please ?
Maybe like :
MyCustomFilter = IF SelectedValue('Facts'[Company]) = "AAPL";
Filter('Facts'[Company Flag],"AAPL"
right ?
Best regards,
MYPE
Solved! Go to Solution.
I found another way to do what I want.
What I needed was just a custom column with 2 conditions :
If [Date] = "01/01/1995" and [company] = "MSFT" then "Microsoft launches Windows 95".
The dashboard is now live on this public URL (data stories gallery) :
You may consider the case closed now.
Thanks
Best Regards,
MYPE (Make Your Process Easier) S.A.S
Can you share a sample of your data? If those two columns are in the same table and have the same values then when you filter one, it should essentially filter the other. But, one thing that you could do potentially would be something like this:
Measure = VAR __filter = MAX('Facts'[Company]) VAR __table = Filter('Facts', [Company Flag]=__filter) RETURN //do something here with your __table var
Not really certain what you are trying to accomplish.
Hi @Anonymous
I'm not sure I understand correctly but if 'Facts'[Company] and 'Facts'[Company Flag] are on the same table and have the same values, if you filter 'Facts'[Company] through a slicer you will be effectively filtering 'Facts'[Company Flag] as well, won't you?
Hi @Anonymous
It is very strange :
when i add "company" column(in table1 or table2) to the slicer, it only show "APPL" avlue, other values don't exsit.
Could you clear me?
Best Regards
Maggie
I found another way to do what I want.
What I needed was just a custom column with 2 conditions :
If [Date] = "01/01/1995" and [company] = "MSFT" then "Microsoft launches Windows 95".
The dashboard is now live on this public URL (data stories gallery) :
You may consider the case closed now.
Thanks
Best Regards,
MYPE (Make Your Process Easier) S.A.S
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |