cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
whereismydata
Resolver II
Resolver II

Column/LIne chart question

Hi,

 

again, something that first seemes simple but then is challenging:

 

I want to visualize income/cost/profit of different products in one visual.

whereismydata_1-1636711716761.png

where the red line is 0, values below are cost, above income, grey line is profit, X axis =  date, Y axis = values

 

currently I've got one table where all data is stored. costs are negativ values:

| DATE | Product | Category 3 | Category 2 | Category 1 |

 

What I want to achieve:

I want to drill down on the categories. Currently I can only drill down on date. Idealy I would like to first show category 1, than drill down to Category 2, then 3, also drill down on dates should still be possible.

 

I pretty flexible in data modelling. One solution I could think of would be putting all aggregation levels into one table like this:

 

DateProductCategory_NameCategory_LevelValue
2021-01-01Product AA31
2021-01-01Product AB32
2021-01-01Product AC34
2021-01-01Product AD23
2021-01-01Product AE24
2021-01-01Product AF17

 

This, I think, would allow me to then filter on the Category level.

 

But is there a more elegant solution to this problem?

 

Thank you very much!

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @whereismydata ,

 

Try something like this:

Icey_0-1637314245802.png

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @whereismydata ,

 

Try something like this:

Icey_0-1637314245802.png

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

whereismydata
Resolver II
Resolver II

Hi @lbendlin 

thank you for taking time to look at my question.

regarding you answer:
using a hierarchy was the first think I tried but couldn't get to work. In the column series section I only can insert one field:

whereismydata_1-1637240640370.png

 

 

lbendlin
Super User
Super User

You don't really want to include hard coded aggregations if you can achieve the same from your raw data. So if you have data on the lowest granularity level (day and Category 3, I guess) you should then be able to add hierarchies as needed.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors