Forum Discussion

DataGeo's avatar
DataGeo
Helper I
8 years ago
Solved

Combination chart showing average rather than actual data values with combined dates

I've got 2 different excel sheets of data within the same time period, but one table is simply by year while the other has specific days within these years. Different date formats basically.   I am...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Share the link from where i can download your workbook.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my solution from here.

     

    Hope this helps.

     

DataGeo's avatar
DataGeo
Helper I
8 years ago

Hi Ashish,

 

The stacked bars represent the donation amounts from the table, the line should represent the price in the other table. In the shown visualization of the combination the line is 'summed' and only showing a single value over the date range.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share the link from where i can download your workbook.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      You may download my solution from here.

       

      Hope this helps.

       

      • DataGeo's avatar
        DataGeo
        Helper I
        8 years ago

        Hi Ashish, 

         

        Really appreciate your help with this. I am trying to recreate your solution with my original workbook so I can learn the techniques here. I have been able to follow most of the DAX coding but am stuck now on one step. It seems you created a new "Date" column on the donation table to match the date format of the calendar table.


        However when I use the code in your PowerBI file it is giving me an error, see image:

         



        Any idea what I'm doing wrong here? So close!!