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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
SaiJ301120
Regular Visitor

Displaying Change Indicators

I Have a requirement to show the previous month value and previous of previous month value in individually and betwwen these two to have an arrow indication if the present month value has increased,decreased or same when compared with the previous month .

Are there any specific visuals which can help me in this regard or if there are any workaround with the exisiting visuals . the values are currently represented in the card visual but arrows indications i cant figure out how to put them .

SOmething like this pfo.png

 

Any Help is Appreciated !

1 ACCEPTED SOLUTION

hi @SaiJ301120 

something like this?

FreemanZ_0-1675593258139.png

 

Indicator = 
VAR _valuecurrent = SUM(TableName[Projects Delivered])
VAR _valuecurrentlm = 
SUMX(
    FILTER(
        ALL(TableName),
        TableName[Date]=EDATE(MAX(TableName[Date]), -1)
    ),
    TableName[Projects Delivered]
)
VAR _diff = _valuecurrent - _valuecurrentlm
RETURN
IF( _diff>=0, UNICHAR(9650), UNICHAR(9660))

 

View solution in original post

7 REPLIES 7
FreemanZ
Super User
Super User

hi @SaiJ301120 

 

it is achievable with the standard card visual.

try to feed the measure with a measure like:

Measure = 
VAR _value = 0.2  //replace 0.2 with others, like a measure
VAR _pct = FORMAT(_value, "0.0%")
RETURN
IF(_value >0,  _pct & UNICHAR(9650), _pct & UNICHAR(9660))

 

it worked like:

FreemanZ_0-1675583343652.png

 

FreemanZ_1-1675583365410.png

 

 

Hey Freeman , Thanks for answering my quesion but can you elaborate on this please i can provide you with the sample data if needed .

what i precisely need is as per the picture i have provided and giving me the measure defintions would be more helpful .

Thanks

This is the sample data , what i wanted to do is display is both dec and jan values and have an indicator displayed with the difference indication if project delivery has increased or decreased .i do not need the difference to be displayed just the indicator should be enough

MonthProjects DeliveredValueComments
Sep-228120No issue
Oct-229110NA
Nov-22760No issue
Dec-22770No issue 
Jan-236100

Data Breach Issue

hi @SaiJ301120 

something like this?

FreemanZ_0-1675593258139.png

 

Indicator = 
VAR _valuecurrent = SUM(TableName[Projects Delivered])
VAR _valuecurrentlm = 
SUMX(
    FILTER(
        ALL(TableName),
        TableName[Date]=EDATE(MAX(TableName[Date]), -1)
    ),
    TableName[Projects Delivered]
)
VAR _diff = _valuecurrent - _valuecurrentlm
RETURN
IF( _diff>=0, UNICHAR(9650), UNICHAR(9660))

 

Hey @FreemanZ   Thanks Heaps for all the support you have provided , i was able to crack the requirement and it is now working good . 

This can work but i want to display only the last two months that too in a format like two individual visuals for the previous and previous of previous (Just those two) and and an indicator for which i suppose we can use a card with unichar values for indications .

 

one like the picture i have provided in the doubt above 

SaiJ301120_0-1675594358859.png

 

 

Thanks for all the Effort .

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.