Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

First date with another color

Good morning,   I have a table of items with values and I want to make a chart that shows me the values of the first date with another color. Can you help me?   Example: ITEM    DATA        VALU...
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can make this with the Charticulator visual and the two measures shown.

 

First Value = FIRSTNONBLANKVALUE(FirstBarChart[DATA], CALCULATE(MIN(FirstBarChart[VALUE])))
 
Total = SUM(FirstBarChart[VALUE])
 
 
If needed, the template file for the Charticulator visual is attached.  I couldn't attach a .tmplt file directly, so take the text from the Word doc, put it in notepad and save it with an extension of .tmplt.  You can add that visual to your report from AppSource (Free), and then import this template file and map your data (the column and the two measures).
 
Pat