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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ksiufromtoto
Frequent Visitor

Decomposition Tree Tooltips

Hi! I've got a decomposition tree which analyzes metric "FPY" which is expressed in percentage and I want to add a tooltip field "_Failed" with integer values. The problem is that for some reason failed is shown in percentage. I've switched those measures so that failed is analyzed and now fpy is shown as float. Has anyone had this problem as well?

 

ksiufromtoto_0-1640943775725.png

ksiufromtoto_1-1640943792236.png

 

4 REPLIES 4
v-chenwuz-msft
Community Support
Community Support

Hi @ksiufromtoto ,

 

Have you switched all these measures or columns to a percentage type? 

Maybe you should set FPY as % and _failed as number.

vchenwuzmsft_0-1641264426472.png

vchenwuzmsft_1-1641264500181.png

result:

vchenwuzmsft_2-1641264556175.png

 


Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi, yes, I've tried but it didn't work. The only solution I came with is to use FORMAT function. But it seems like a bad decision overall as Failed and FPY are tabular model measures

Hi @ksiufromtoto ,

 

Can you share some screenshot of this measure, include it type and formula. Or you can share the pbix without sensitive data.

 

Best Regards

Community Support Team _ chenwu zhu

VijayP
Super User
Super User

@ksiufromtoto 

You must have a measure to get the % , Create measure for Percentage and then you can get the result




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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