Tracking Between Dates

[Bahalzamon]

I have some Vulnerability data that has a Detection Date and a Last Detected Date field.

I have many visuals breaking down the data by Year/Quarter but it is all off of one of the dates.

I am hopeing to identify a way to visualize this data in something like a stacked bar chart. So I am currently using Last Detected and its having the most current quarter/year with the most identified, but id like it to show on the previous quarters that the vulnerability was there.

Hopefully I am explaioning it well enough, but for an example I have a vulnerability detected 1/1/24 and its last detected 6/1/24. For my current visuals that individual will show up in the Q2 chart. I would like it to show up as another color in the stacked bar chart letting them know that this vulnerability was in Q1 and Q2.

Heres a quick visual, many of the ones in Q3 should be represented in the Q1 & Q2, but since I am using Last Detected it only shows it in Q3. At a minimum I would just like the total numbers to be updated showing the proper vulnerabilities if it is in that date range.

NOTE: I am ONLY looking for a way to get the data to visuals most likely through a measure, I do not care about any color formatting.

[amitchandak]

@Bahalzamon , when you use legend or multiple measures, then you can not use conditional formatting.

If you are using multiple measures, you can create a calculation group and use that on x-axis, Expand. Now you can use conditional formatting

You can use a measure like below in conditional formatting of column using field value option

COlor =

var _max= maxx(allselected(Table), Table[Qtr])

return

if(Max(Table[Qtr]) = _max, "Red", "Green" )

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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

[Bahalzamon]

I will update my post, but I am looking for a way to create a measure or something that can show the data of the total vulnerability count not some coloring.

I need the data showing in Q3 to show also in Q1 & Q2.