Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello
I have a table that calculate sum of sales by month, for example:
my goal is that when i choose month in the slicer, i want to see 0 or blank in those month's i didnt choose.
as you can see, I sliced the table by months 1,2,3, the total is good (blue column) but i see the values in the other months.
I calculate the month by :
1= calculate(sum(sales),month=1) and so on.
I cant use matrix, only table.
Thanks.
Solved! Go to Solution.
I figure it out with this measure:
Thank you !
Hi Bidev,
can you upload the pbix file in wetransfer.com?
I will help you!
Thank you,
I cant upload the original one but i created a test file.
https://filebin.net/y9s5e34i4odxs4m4
thanks