Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi,
I'm working on the table below.
This table is showing the last quantity registered of the products in the storage by year/month/week or day (according to the drill-down ).
The Visual Value space is filled with this measure:
Last quantity registred= CALCULATE(SUM([Quant.]; LASTDATE ([date]))
As you can see, I'm trying to put some conditional format to indicate when the quantity increased ou decreased in comparison to the column on its left but I did not figure out yet...
Someone can help me, please?
EDIT**
Here is a .pbi file for an example
Hi @Pedro_Lourenco ,
We can use the following steps to meet your requirement.
1. Create an icon measure,
Icon Set Measure =
VAR difference =
VAR sum__ =
VAR cdate =
MAX ( 'Table'[Date] )
VAR pdate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALL ( 'Table' ), 'Table'[Date] < cdate )
)
RETURN
CALCULATE (
SUM ( 'Table'[Quant] ),
FILTER ( ALL ( 'Table' ), 'Table'[Date] = pdate )
)
VAR sum_Q =
CALCULATE ( SUM ( 'Table'[Quant] ) )
RETURN
sum_Q - sum__
RETURN
SWITCH ( TRUE (), difference < 0, -1, difference > 0, 1, 0 )
2. Then we can configure the [Last quantity registred]’s icon based on [Icon Set Measure],
3. At last we can get the result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
BTW, pbix as attached.
Best regards,
I Edited the post and inserted a pbix file so It could be easy to understand.
Basically I want to conditional formating based on the difference of the numbers in the columns by product, even when I drill up or down to see different time periods.
The Question is not much clear. I can see the trend if the left column is high current column showing red and vice a versa
Request you to eloberate the problem statement
Proud to be a Super User!
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 37 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 68 | |
| 67 | |
| 30 | |
| 26 | |
| 26 |