Forum Discussion

Ivan4ever84's avatar
Ivan4ever84
Frequent Visitor
2 years ago
Solved

Multiple slicers over single column

Hi folks, I'm sharing the latest challange that happened to me. I need to create a report where the user has the chance to select the versions of the various operating systems in order to define the scope of obsolescence (which OS are supported and which are EoL).
The current dataset has a single column where the operating system version is reported in different format because each vendor uses its own nomenclature. I would like to create a visual slicer for each type of system (Windows, Red Hat, Suse, etc) where it is possible to select the version of the operating system which will represent the lower limit below which all versions will be considered obsolete.
In this way I will be able to provide a dynamic dashboard for obsolescence management to the end user who can use the slicers to define the scope now and in future.

Below is an example of the datased and a draft of the visual filters. Each slicer should filters only its Product (es. Windows) leaving the other OS versions available for the other slicers.
How would you proceed? Obviously it is possible to work with it using Power Query / DAX.

 

Thank you very much! 🙏

 

  • Step 0: I use your data.

     

    Step 1: I add 2 columns below on Power Query Editor.

     

     

    Step 2: I replace 'null' to '9999'.

     

    Step 3: I make a table and 2 slicers.

     

     

     

1 Reply

  • Step 0: I use your data.

     

    Step 1: I add 2 columns below on Power Query Editor.

     

     

    Step 2: I replace 'null' to '9999'.

     

    Step 3: I make a table and 2 slicers.