Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All
@VijayP have share with me Advanced Card , This Vis is must better then PBI Card Visulisation.
Because it can display more information in one card.
When i try to use the below expression for display % Vari :-
Above is PBI file :-
Solved! Go to Solution.
Select your measure in the Fields panel and then click on the % sign to format it as percent in the ribbon. Also, you should write that measure using a variable to keep it from calculating twice each time.
_Vari_%_REV =
VAR vResult =
DIVIDE (
[_YTD REV] - [_LYTD REV],
[_LYTD REV]
)
RETURN
IF (
ISBLANK ( vResult ),
1,
vResult
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Select your measure in the Fields panel and then click on the % sign to format it as percent in the ribbon. Also, you should write that measure using a variable to keep it from calculating twice each time.
_Vari_%_REV =
VAR vResult =
DIVIDE (
[_YTD REV] - [_LYTD REV],
[_LYTD REV]
)
RETURN
IF (
ISBLANK ( vResult ),
1,
vResult
)
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat Thank you very for sharing the right approach in writing expression. it is more structure.
Paul
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
70 | |
63 | |
55 | |
48 | |
46 |