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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
slaytoday17
Frequent Visitor

Visual refusing to change decimal places

Hi everyone,

 

I am having some trouble with changing the decimal places on a value shown in a Card. I have tried two ways to change it:

 

1) Clicking the measure name in field -> measure tools 

 

2) Visualization --> Visual -> Callout value

 

Unfortunately, none of these methods work. 

 

As I've had success in changing the decimal places of other cards, I am thinking it may be a filtering problem?

 

My sample data looks like this:

 

Table

Rate
-
0.31092823
0.31298135
0.88575758
0.92084190

 

And I am trying to get the minimum value of this column, which using Power BI's quick measure gives me this:

 

Lowest detection =
MINX(
    KEEPFILTERS(VALUES('table'[rate])),
    CALCULATE(MIN('table'[rate]))
)
 
Which without filter, returns value "-".  
 
Therefore, I have applied a visual level filter on 'rate' where I exclude "-", and doing so does give me the right value but with too many decimal places
 
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@slaytoday17 , In the measure tool you should be able to fix decimal place , or you use the round function

 

amitchandak_0-1669948163708.png

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@slaytoday17 , In the measure tool you should be able to fix decimal place , or you use the round function

 

amitchandak_0-1669948163708.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.