Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
I want to display 7.8% on the card but it gives - 0.08 as net growth rate.
I've added an index column to the table and used the below formula.
The formulae that I used -
Solved! Go to Solution.
Hi,
Select the measure and change to % in the measure tools that appears when you select the measure
Hi @Nivedita ,
Your DAX will try to return the Net Growth Value in the row with Index that matches the Max Index value. I used the same DAX the you gave
By that case, 0.08 is returned as the Index for that record is greater and matches with the MAX of Index column
This 0.08 if you convert as % will show 7.8% which is the record with max value for index
Hello Thejaswar. How do I show it in percentage?
My bad, looks like it's displaying the decimal value. How do I make it 7.8%?
Thank you for your response.
Hi,
Select the measure and change to % in the measure tools that appears when you select the measure
Thank you very much.
Hi @Nivedita ,
Hope you have tried with directly taking max of Net Growth Rate column in Card visual like below:-
or If its affecting due to any other field then you can try below code in measure and use it on card visual:-
Measure =
CALCULATE (
MAX ( 'Overall'[Net Growth Rate] ),
ALLEXCEPT ( 'Overall', 'Overall'[Net Growth Rate] )
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
111 | |
104 | |
84 | |
65 | |
63 |