Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add Sales from Different Table

Hi There,    I am putting together a line Graph of Current year, PY and Budget sales.   To get this, I have to combine two different Tables.    Table1 Includes Full budget, full 2019 and Jan - ...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

It seems like you use the month hierarchy in the axis and your measure like [Table1 GSV20] has quoted whole values about 2019 so that it will reflect in the line chart.

One way to solve this is use the visual filter to just show only 5 months in line chart.

 

Or could you please consider sharing your measure or a dummy .pbix file for further discussion?

 

Best Regards,
Yingjie Li

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, I did have it filtered by the month. When I changed it to the day, it worked.

     

     

    v-yingjl