cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DMSJennifer
Helper I
Helper I

Compare values from 2 visualized tables in powerbi dashboard (NOT BACK END TABLES COMPARISON)

Hi there, 

 

I have a challenge for the expert powerbi community!! Within my company we are currently looking to compare two table values in the powerbi dashboard (FRONTEND) to return an marker wheter the individual green value (which is filtered by "studiegroep", "periode" & "voornaam") meets the groupbenchmark pink value (filtered by :"benchmarkyear" but with changing data based on a backend division of data). 

DMSJennifer_1-1642684781461.jpg

 

Using PowerQuery within the tables is not possible given the pink data is changing when using diffent filters (so the pink data is not directly from another back-end table but is only generated in the dashboard by using measures & filters in the dashboard.

 

Normally in excell you would simply make a calculation based on the respective cells (see example below) and add a conditional formatting, see example in excell. However, I am looking for a similar solution within the powerbi dashboard. Is this possible in PowerBi?

 

DMSJennifer_3-1642686359935.png

 

would love to hear from anyone who can offer help! 

 

 

 

 

2 REPLIES 2
ValtteriN
Super User
Super User

Hi,

You can create a conditional measure which returns 1 or 0 based on the "cell value" or in this case matrix position.

In my example I have two tables similarly to your case example:

ValtteriN_2-1642688501102.png

 

 

ValtteriN_1-1642687954883.png


Unfortunately since the dimensions in your example we have to do some hard-coding similarly to referring cells we will be referring to values.

Dax:

Conditional format for group =
var _dim1 = MAX(ConditionalMatrix[Dimension])

return

If(
SUM(ConditionalMatrix[Value]) //same as current "cell" value
>=
CALCULATE(SUM('Comparision conditional matrix'[Value]),ALL('Comparision conditional matrix'),'Comparision conditional matrix'[Dimension]=_dim1,'Comparision conditional matrix'[Selection]="group"),1,0) //comparion "cell" value
Place the measure here:
ValtteriN_4-1642688590082.png

 

ValtteriN_5-1642688610252.png

 


 
End result:
ValtteriN_3-1642688546072.png

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!









Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @ValtteriN,

 

Thanks for your time, its means a lot. However, it is not exactly what I am looking for but you might still be able to help. 

 

To clarify a bit more let me explain were our data is coming from:

DMSJennifer_0-1643287447163.png

Pink: Front-end

Green: Back-end 

 

With this in mind I've looked at your solution, which would work if in my example the  "group" matrix shown would come from a back end table (like you created two tables, which allowed you to make a difference back-end measure "conditional format for group" with the different values (that exist in a backend table).

 

However, this is not the case, the data that I use as a comparison - in the "group" dashboard matrix - is only shown in the front-end dashboard, so it does not exist as back-end table or value. Its merely showcasing data calculated in a front-end measure (and based on different filters), so there is no actual value that I can reference in a dax formula. Or at least this is where I am stuck. I would like to reference specific data only shown in a front-end dashboard table in a dax formula.  Is this possible?

 

Thanks again!

 

 

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors