Forum Discussion

wfeng's avatar
wfeng
Regular Visitor
6 years ago
Solved

How to show comparing date in bar chart?

Hi everyone,

 

I am working on a simple data set, like that:

When I put them in a bar chart, it will show like:

My setting is:

However, what I want is like this:

 

The issue is the date data was counted, but I cannot figure out how to discount it.

 

I will very much appreciate you if anyone can tell me how to do it. Thanks!

 

 

 

 

 

 

Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    I would look through appSource visuals to see if something there meets your needs. Alternatively, you can trick an array into doing this by making a date table (unrelated to the data), a measure that compares the date with the completed/expected dates, and the conditional formatting in the background and font. See the following example, using the week column of a date table (you could use date, month, and so on) to get the result. It also uses the Show in Rows function of the array visual.

    mahoneypat_0-1597410302576.png

    The measures used above are (replace BarChart with the actual name of the table)

    Esperado. • var mindate - MIN('Date'[Date])
    return if(mindate<-MIN(BarChart[Expected]),1)
    Completado. • var mindate - MIN('Date'[Date])
    return if(mindate<-MIN(BarChart[Completed]),1)

    If this works for you, mark it as the solution. Praise is also appreciated. Please let me know if you don't.

    Best regards

    Pat

10 Replies