Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Getting data from a slicer

Hey. 

 

I have a slicer on the left hand slide and it is an order number. On the right i have 3 cards. The cards need to be filter on the code within the slicer which is opposite. 

So there are 3 order numbers and each one has 3 cards (each card has to display a count on Yes, No and Not applicable). 

 The cards on the right need to be filtered to each order number wtthin the slicer. So all told i need 9 cards (3 for each order number wthin the slicer). I am not sure of a quick way of doing this with or without DAX. 

 

Any ideas would be fab - thanks J. 

Data Protection
Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous not sure why you want to visualize the data this way, it is not very scalable, why not use a simple matrix visual, orders on the row, status on column and values will be count.

     

    What you are trying to achieve by visualizing the data using Cards and Slicer?

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡