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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
forgetmenot
Helper I
Helper I

Card visual ignoring values under 0!

Hi all, 

 

I hope someone can help me. I have created a measure to bring back the value of a particular month. This works for absoute values. However, when value is minus it shows it as blank. 

I want to be able to show the actual value i.e  -£10,000 etc. 

 

How can I acheive this? I am a beginner so would apprecaite any help.

 

I have used the following measure: 

 

Measure= CALCULATE(SUM('KPI'[Value]),

DATESINPERIOD('KPI'[Date],DATE(2023,06,01),-1,MONTH))
1 REPLY 1
mlsx4
Memorable Member
Memorable Member

Hi @forgetmenot 

Can you share a sample of your file? It's difficult to understand what's happening without knowing how it is defined.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.