Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI Everyone,
If filtered the month in slicer then sales should be displayed for zero values also for example please find the screenshot below.
IF i select Month as 5 or 10 as in below picture there is no sales for product 5 and 6 but when we filter months 5 or 10 the output showing only product 10 and 11 only but my requirement is as shown in below pic.
if there is no sales then it has to display zero value in Table
Thanks in Advance
sandeep
Solved! Go to Solution.
Hi,
The trick is to restructure the data table:
So, now when you will use the slicer to filter the table, it will give you the desired result:
Hope this should answer your query.
Thanks,
Vivek
PS: I have used Excel but same can be replicated in PowerBI desktop.
Please mark it as accepted solution if it answers your query.
Here is the pbix file
Thanks,
Vivek
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |