Visualization of sales by year

[david40ni]

I need to show a report like the below where I can add the year to a chart I no we have a bar chart but I am trying to figure out how I can have year as an axis against the sales ?. Also is there any visulization that would give that a plus or minus look like the item group report

[v-juanli-msft · Accepted solution]

Hi @david40ni

Add "date" column to the Axis field in the column chart, and turn it to "Date Hierarchy", then delete "day","month","quarter", but only keep "year".

another visualization can use a table visual and then apply conditional formatting.

To get the visual below, you need create some measures

total applied databar = MAX([total])

flag = IF(MAX([vs])>=0,1,0)

plusorminus = IF([vs]>=0,CONCATENATE("+",[vs]),CONCATENATE("-",[vs]))

Reference:

desktop-conditional-table-formatting

dataBars

Best Regards

Maggie

[drewlewis15]

Power BI will automatically create a date hierarchy based on your date field, so you can add that date field to the axis and get your desired result.  

The other visual would be a simple table with conditional formatting applied along with a measure to show the + -, which is all possible within Power BI.