cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jkaelin Member
Member

Can this be done in Power BI? Don't need solution, just to know if capability exists

Multi_Factor.PNG

 

 

 

 

 

 

 

 

About:

Above is a snap shot of a report in a pivot table (Excel) that is one of two main reports at my firm.  The conditional formatting is based on another tables value.  {Green for value less than 0.75; Yellow between 0.75 & 1.00, Red for greater than 1.00}.  The {0.75, 1.00} values are not absolute values, but values that change overtime and are stored in another table.

 

Question:

My question is whether or not this can be done in Power BI in some capacity?

 

Additional Info:

I know the conditional formatting does not exist...yet... in Power BI; would it be possible in a measure?  

 

Kindly,

James

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

Hey,

 

in someway there is some kind of conditional formatting, but unfortunately not in a way to answer your requirement, for this reaon I use some kind of measure that is responsible for the column Light

Some kind of traffic lights.png

 

The measure utilizes the capabilities of the "mystic" function UNICHAR :-) and looks like this

Light = UNICHAR(if(AND([Amount PY] >= 0, [Amount PY] < 140), 128213, if(AND([Amount PY] >= 140, [Amount PY] < 200), 128210, 128215)))

From a usability point of view, this is much less than can "easily" achieved in EXCEL but the degree of freedom is beyond, besides the aspect that you have to use your own column.

 

Hope this gives you an idea

 

Regards

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

12 REPLIES 12
Super User
Super User

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

Hey,

 

in someway there is some kind of conditional formatting, but unfortunately not in a way to answer your requirement, for this reaon I use some kind of measure that is responsible for the column Light

Some kind of traffic lights.png

 

The measure utilizes the capabilities of the "mystic" function UNICHAR :-) and looks like this

Light = UNICHAR(if(AND([Amount PY] >= 0, [Amount PY] < 140), 128213, if(AND([Amount PY] >= 140, [Amount PY] < 200), 128210, 128215)))

From a usability point of view, this is much less than can "easily" achieved in EXCEL but the degree of freedom is beyond, besides the aspect that you have to use your own column.

 

Hope this gives you an idea

 

Regards

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

Jkaelin Member
Member

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

@TomMartens

 

Thank you for the speedy response.  The workaround is professional.  I look forward to the day MS is able to expand their conditional formatting capabilities in Power BI, but this is a solid workaround in the mean time.

 

Thank you,

James

Jkaelin Member
Member

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

@TomMartens

 

Having trouble getting this to execute properly.

 

How did you get colors on them?  Conditional formatting or are the UNICHAR # supposed to already be colored?

 

 

 

 

Highlighted
Super User
Super User

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

The UNICHAR # are already colored, if you are on Windows 7 this might be an issue, Windows 10 and Power BI service works flawless, as you can see on my pictures ;-)

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Jkaelin Member
Member

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

@TomMartens  

 

I am on Windows 7.  This could be the source of the problem.  Thank you, give me something to work on.  

Super User
Super User

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

Time to migrate ;-)

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Jkaelin Member
Member

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

@TomMartens

 

My IT dept. would have a cow....but I hope MS rolls out measure based conditional formatting soon & that'll be huge for our adoption.

Super User
Super User

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

Hey,

I wouldn't bet a cow on what will arrive first.

But maybe you want to try another approach. In this thread https://community.powerbi.com/t5/Desktop/power-bi-Table-Visuilation-in-R/m-p/234095#M104251 I mentioned the R package gridExtra. Personally my favorite solution if the table is not huge and you need complex formatting in your table. The only drawback, currently a R script visual is not interactive.

Regards
Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
ARB17 Regular Visitor
Regular Visitor

Re: Can this be done in Power BI? Don't need solution, just to know if capability exists

Morning,

 

I tried to apllied this solution but it just shows black squares, without color. Is this valid anymore? The field (a measure) is formatted as Text.

 

Regards,

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 80 members 1,264 guests
Please welcome our newest community members: