Forum Discussion
Helper VFill in value from the line below
Hey guys,
I have a matrix with the release date, the stock completion date, and the gap (time from stock completion to the next release. What I would like to get is that if the gap is negative, it also fills in with the same color as the next launch that is on the line below.
How could I create a measure?
kasife , You can get the next release date in a column
next = Minx(filter(Table, [release Date] > earlier([release date]) ), [release date])
you can take a diff
diff = datediff([Stock Check out],[next], day)
you can now use conditional formatting. you can create a measure and use that in conditional formatting using field value option
if( Sum(Table[Diff]) >0 , "Green", "Red")
Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
1 Reply
- amitchandak
Super User
kasife , You can get the next release date in a column
next = Minx(filter(Table, [release Date] > earlier([release date]) ), [release date])
you can take a diff
diff = datediff([Stock Check out],[next], day)
you can now use conditional formatting. you can create a measure and use that in conditional formatting using field value option
if( Sum(Table[Diff]) >0 , "Green", "Red")
Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s