Forum Discussion

Tasos's avatar
Tasos
Icon for Helper II rankHelper II
7 years ago

Dynamic summarize

Hello,   A question that can either be really easy to answer or too difficult.   I have a database with Orders; Order numbers, product code, date, quantity sold and various other flags (country, ...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Tasos i looked at your pbix, not sure why there is a need of summry table. Can you clairfy ?

Tasos's avatar
Tasos
Icon for Helper II rankHelper II
7 years ago

parry2k, Chihiro, LivioLanzo

 

Thank you all for the immediate reply. 

 

I am not really sure if I do need the summary table or not. The reason why I thought I need it, as I mentioned in my first message,  is that the same order can have multiple products/countries etc. What I want to create is a dynamic bar chart where in the X-Axis I am having the different numbers of order lines and the number of orders is used as a value. (in the pbi file, I have added the wanted graph)

 

I am looking at Chihiro reply now. Hopefully, my text above helps you understand my original message.

 

Thanks again for your time

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Tasos it is clear now what you are looking for, there are many way to achieve but going with dimension to link with summarize table is easier way.