Forum Discussion
Tracking Between Dates
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.
2 Replies
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU
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.
