Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous
Not applicable

Calculate with Slicer

Hello

 

I have a table that calculate sum of sales by month, for example:

BiDevOO_0-1696757128580.png

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I figure it out with this measure:

BiDevOO_0-1696759896595.png

Thank you !

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I figure it out with this measure:

BiDevOO_0-1696759896595.png

Thank you !

lucadelicio
Super User
Super User

Hi Bidev,

can you upload the pbix file in wetransfer.com?

I will help you!

Thank you,



Luca D'Elicio

LinkedIn Profile
Anonymous
Not applicable

I cant upload the original one but i created a test file.

 

https://filebin.net/y9s5e34i4odxs4m4

 

thanks

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!