Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm trying to visualise a line graph with count of sales over time (month) between two countries A& B and the Total Sales count(Country A+B). So the Idea is to have a slicer with Country A, Country B and the Total. When a user selects for example Country A it will display the count of sales for that particular country and the Total(two Line Graphs). Then when a user selects total it shows all Country A & B then a (total count for Country A&B)- Three Line graphs. This should be in one visual chart.
I have tried making a control table with the following then creating a relationship with the country. However, I seem to get an error when I select on the total after creating the following measure;
CountyID = MIN[Country[ID])
Selected Country = SWITCH([Country ID],
1, [Measure created with count sales "Country A"],
2, [Measure created with count sales "Country B"],
3, [Count County A] + [Count County B]
Type | ID |
A | 1 |
B | 2 |
Total | 3 |
Please help
Solved! Go to Solution.
Hi,
I suggest having a disconnected slicer table like below.
Please check the below picture and the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I suggest having a disconnected slicer table like below.
Please check the below picture and the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |