Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 choose 2012, my visualization should show id 1 = 1 in sales year 2012 and id 2 = 1 in Sales year 2012. Instead it is showing up as id 1 = 3 and id 2 = 1. My understanding is that if it sees atleast one id in 2012 it counts all instances of it within in the table. Does anyone know how to change this?
id | salesYear|
--------------------|
1 | 2012 |
1 | 2013 |
2 | 2012 |
1 | 2015 |
Solved! Go to Solution.
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.
Please download the .pbix for reviewing more details.
Best Regards,
Angelia
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.
Please download the .pbix for reviewing more details.
Best Regards,
Angelia