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
Anonymous
Not applicable

I want to show percentage change with icon next to the records in matrix view

Business users want to see percentage change in the matrix view with icon 
please see attach below here : 

8142023.png

 

is it possible to get exact the same look here ? if not possible the same look in POWER BI, I'd like to know optional solutions as well.

I know that we can add icons within power bi, and selecting one column and identifying conditional format, fine 
but how about the measure ? and this measure (percentage) should apply for each year?

I couldn't come up with any idea for this particular situation.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Anonymous 

That is exactly what I am afraid you will not be able to accomplish.

Similar results are definitely possible.

I have attached a picture for your reference.

Of course, you can put any shape you find to copy in the arrows

Each column in the table represents a measure

In order to demonstrate, I made only one triple, but you can make more if you want

Ritaf1983_0-1692068791156.png

Link to my PBIX with an example 

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

 

View solution in original post

12 REPLIES 12
Anonymous
Not applicable

I just look at pbix file here and I like it, this is pretty much it - choose your icons, change text color on average - 
only issue is here;

ok we have one category field, and we should have one year column (it contains 6 years) but I changed the tile to matrix and here it is ( attached below )
8-15-2023.png

1 ) can we create a measure that dynamically calculating depending on the year ?
2 ) can we create a measure <0 red, >0 green so I can use this measure for font color conditional formatting ?

@Ritaf1983 

Hi @Anonymous 
If I understood you correctly, you can achieve it by calculating the function

"static way " - something like 

2022 = Calculate ([your measure] , 'your table [year] = 2022

(same measure as each year with needed filter)

or using date table and time intelligence functions.
, but then you will meet a new problem: the measure name cannot change dynamically.
you will need to give some reference names such as "Current year", "Current year -1", "Current year -2", etc... 

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

Anonymous
Not applicable

in the table view, yes there will be 6 different percentage measures to calculate each year comparison
how about instead of 6 different measures ? can we create one measure to put in the values field for matrix tile ? so it will adjust the records respecting year ? Do you think we can achieve that or no ?
@Ritaf1983 

I don't think that it is going to work, but you can try...

Anonymous
Not applicable

@Ritaf1983 
hi Ritaf, I couldn't figure it out yesterday by myself but, I believe it's possible by looking at this video below : 

https://www.youtube.com/watch?v=L2ELtem2iGY&ab_channel=BIElite

I'm accepting your solution, since this looks good within pbi limitations.
thank you.

Hi @Anonymous if you will attach some sample data i can try to help more 🙂

Anonymous
Not applicable

I wish I could but I can't use the data that I'm working on it now.
but it's so similar to your sample @Ritaf1983 

Anonymous
Not applicable

I handled number #2 here 

percentage color = IF ( [%] > 0,  "#73B761" , "#DB271C" )
@Ritaf1983 

how can we handle number #1 ?

Hi @Anonymous 
I found a dynamic solution for percentages.
You can download the updated file from here:

Link to the updated file 

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

Anonymous
Not applicable

Hey thank you for following up, I really appreciate it. 
this proves it's possible, so I can tweak the logic on my end as well.

Glad to help 🙂

 

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

Ritaf1983
Super User
Super User

Hi @Anonymous 

That is exactly what I am afraid you will not be able to accomplish.

Similar results are definitely possible.

I have attached a picture for your reference.

Of course, you can put any shape you find to copy in the arrows

Each column in the table represents a measure

In order to demonstrate, I made only one triple, but you can make more if you want

Ritaf1983_0-1692068791156.png

Link to my PBIX with an example 

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

 

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.