Change the entire column of a slicer based on the selection made in another slicer

[Arul]

Hi, We have two business lines (AT, BD) in one slicer. When we select 'AT', we want to see different column values in another slicer, and for 'BD' selection, we want to see different column values. Is this feasible?

[TomMartens · Accepted solution]

Hey @Arul ,

you can achieve this by filtering the values in the 2nd slicer

• if the values are coming from the same column
• if you are talking about different columns, then you can achieve this by using the field parameters feature: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Hopefully, this will help to tackle your challenge,

If you need more guidance create a pbix file that contains sample data (tables, relationships, calculated columns, and measures), upload the pbix to Onedrive, Google Drive, or Dropbox, and share the link. Do. not forget to describe the expected result based on the data you provide.

Regards,

Tom