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.
I have a table Visualization with percentages in power Bi. I want to format it in such a way that I can see an increase or decrease from the previous month. I am not sure how to go about it to be honest. But when I tried, I could see anything that could help me.Please
Solved! Go to Solution.
You can refer to the following solution.
Sample data
Create three measure
Format_fc =
VAR _preffc =
CALCULATE (
SUM ( 'Table'[%Stock to FC] ),
'Table'[Monthnumber]
= MAX ( 'Table'[Monthnumber] ) - 1,
ALLSELECTED ( 'Table' )
)
RETURN
IF (
NOT ( ISBLANK ( _preffc ) ),
IF ( SUM ( 'Table'[%Stock to FC] ) - _preffc > 0, 1, 0 )
)
Format_fcr =
VAR _preffcr =
CALCULATE (
SUM ( 'Table'[%Stock to FCR] ),
'Table'[Monthnumber]
= MAX ( 'Table'[Monthnumber] ) - 1,
ALLSELECTED ( 'Table' )
)
RETURN
IF (
NOT ( ISBLANK ( _preffcr ) ),
IF ( SUM ( 'Table'[%Stock to FCR] ) - _preffcr > 0, 1, 0 )
)
Format_rica =
VAR _prerica =
CALCULATE (
SUM ( 'Table'[%Stock to RICA] ),
'Table'[Monthnumber]
= MAX ( 'Table'[Monthnumber] ) - 1,
ALLSELECTED ( 'Table' )
)
RETURN
IF (
NOT ( ISBLANK ( _prerica ) ),
IF ( SUM ( 'Table'[%Stock to RICA] ) - _prerica > 0, 1, 0 )
)
Then put them to the conditional formatting of the [%Stock to RICA],[%Stock to FC],[%Stock to FCR], select icons
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can refer to the following solution.
Sample data
Create three measure
Format_fc =
VAR _preffc =
CALCULATE (
SUM ( 'Table'[%Stock to FC] ),
'Table'[Monthnumber]
= MAX ( 'Table'[Monthnumber] ) - 1,
ALLSELECTED ( 'Table' )
)
RETURN
IF (
NOT ( ISBLANK ( _preffc ) ),
IF ( SUM ( 'Table'[%Stock to FC] ) - _preffc > 0, 1, 0 )
)
Format_fcr =
VAR _preffcr =
CALCULATE (
SUM ( 'Table'[%Stock to FCR] ),
'Table'[Monthnumber]
= MAX ( 'Table'[Monthnumber] ) - 1,
ALLSELECTED ( 'Table' )
)
RETURN
IF (
NOT ( ISBLANK ( _preffcr ) ),
IF ( SUM ( 'Table'[%Stock to FCR] ) - _preffcr > 0, 1, 0 )
)
Format_rica =
VAR _prerica =
CALCULATE (
SUM ( 'Table'[%Stock to RICA] ),
'Table'[Monthnumber]
= MAX ( 'Table'[Monthnumber] ) - 1,
ALLSELECTED ( 'Table' )
)
RETURN
IF (
NOT ( ISBLANK ( _prerica ) ),
IF ( SUM ( 'Table'[%Stock to RICA] ) - _prerica > 0, 1, 0 )
)
Then put them to the conditional formatting of the [%Stock to RICA],[%Stock to FC],[%Stock to FCR], select icons
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please refer to the linked discussion.
And the linked tutorial
https://radacad.com/month-over-month-calculation-in-power-bi-using-dax
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |