Forum Discussion
Visual to plot all data points for a cumulative measure when there is no data for some periods?
Hi Anonymous
Sorry, I don't quite understand what you're looking for.
You might consider creating a pbix file that will contain some sample data (Not just screenshot), upload the pbix to one drive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
The result I want is relating to my bottom left table/measure to show an answer for each month. Take for example the "near miss" category - I have 1 in Feb and then another in Mar making it 2 but then I dont have another until July making it 3. I want my table to show:
Jan - 0
Feb - 1
Mar - 2
Apr - 2
May - 2
Jun - 2
Jul - 3
Aug - 3
Sep - 3
Just like how the line chart above it is representing the data. It even displays the tool tip for the correct amount when the measure flat lines.
I need this because the FR measure on the right is the same - it calculates the correct FR for the event types but when I use a slicer for the event types, my visual will only show me the months where there is a data entry just like displayed in the table on the bottom right.
The reality is the FR should display in every month because if I have no more incidents in a month where I do have hours (which is every month) then my FR goes down which is good. For example the 3rd measure used on the right in the screen shot is (cumulative events / cumulative hours) * 100,000 - the entry for July and "near misses" is correct at 9.20 but by september it should be (3/44620)*100,000 = 6.72