Forum Discussion

kpansia's avatar
kpansia
Frequent Visitor
8 years ago
Solved

Slicer Not Working as Intended

Hey I have a small sample table example below this. When I am creating visualizations, specifically the stacked column chart, I use a slicer to seperate and count distinct values by year. So If I cho...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi kpansia,

    I reproduce your scenario and get expected result, please follow the steps below.

    1. Create a measure using the formula below.

    DistinctCount = COUNT(Table2[id])


    2. Create a stacked column chart, select the Id as x-axis, the measure as value. Create a slicer including Year field.

    select 2012 yearselect 2013 year

    Please download the .pbix for reviewing more details.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi kpansia,

I reproduce your scenario and get expected result, please follow the steps below.

1. Create a measure using the formula below.

DistinctCount = COUNT(Table2[id])


2. Create a stacked column chart, select the Id as x-axis, the measure as value. Create a slicer including Year field.

select 2012 yearselect 2013 year

Please download the .pbix for reviewing more details.

Best Regards,
Angelia