Forum Discussion

Yian's avatar
Yian
Frequent Visitor
3 years ago
Solved

Pre-set filter button

Hi Community,   I have a 'Comment' column in my table which contains strings 'Reconciliation Successful', 'Reconciliation Unsuccessful', 'Reconciliation Successful; Check Month End Date', and 'Reco...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Yian In this scenario, create another dimension table with two rows "Successful" and "Unsuccessful" and set the relationship of this table with your regular table. In the slicer, use column from this new table and your problems will be solved, both options will be always available, and depending on what you select respective data will be shown in the visual and if there is no data the visual will be blank.

parry2k's avatar
parry2k
Super User
3 years ago

Yian In this scenario, create another dimension table with two rows "Successful" and "Unsuccessful" and set the relationship of this table with your regular table. In the slicer, use column from this new table and your problems will be solved, both options will be always available, and depending on what you select respective data will be shown in the visual and if there is no data the visual will be blank.