Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter the visual using a column based on some selected value from slicer using different column

Column AColumn BColumn CColumn D
AA1A2DATAFLOWID1
BAB1B1DATAFLOWID1
CTTDATAFLOWID1
DDADDATAFLOWID2
EAEAE3DATAFLOWID2
FOODATAFLOWID3

I have a data like this and i want to use a slicer from field "Column A", based on the selected value from the slicer i want to evluate a condition like, if that selected value is present in either of "Column B" or "Column C" then fetch the "Column D" value and filter he visual using those "Column D values".
For example if the selected value is "A"  and the "Column D" values which satisfies he condition mentioned above are "DATAFLOWID1" and "DATAFLOWID2". filter the visual based on these values and output will okk like this

Column AColumn BColumn CColumn D
AA1A2DATAFLOWID1
BAB1B1DATAFLOWID1
CTTDATAFLOWID1
DDADDATAFLOWID2
EAEAE3DATAFLOWID2


Any solution is welcome and thanks in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    Unforgettable, power bi slicer not able to achieve your requirements based on current table structures.
    I think you need to unpivot your fields n on query editors side and convert your fields to attribute and value, then you can create a slicer with attribute fields value to choose which field displayed on your chart:

    Dynamic Attributes In A Power BI Report 
    Regards,

    Xiaoxin Sheng

3 Replies