Forum Discussion
Need help or guidance to visualice data
English is not my first language so I'm sorry.
Here's what I'm trying to do and my first solution to it; I need to visualice two amounts of money: a planned amount and a real amount to see whats de difference between them, also I need the accumulative amount month per month; if feb. is 100 dollars and march is 200 then I need to visualice the money paid in march plus de money paid in feb. like a stacked pile. My solution to this is a combined chart where the real money are stacked bars and the planned money is a line. I don't know if this is the best solution to this problem, but in any case, I need a little bit of guide.
Hi ScripTeapot_ ,
Based on your description, I have created a simple sample:
Please try:
First create a date table:
Then manage relationship:
Then create the visual:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-jianboli-msft
Community Support
Hi ScripTeapot_ ,
Based on your description, I have created a simple sample:
Please try:
First create a date table:
Then manage relationship:
Then create the visual:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.