Forum Discussion

HT123's avatar
HT123
Frequent Visitor
7 years ago
Solved

Date Filter

Hello everybody,   my report in Power BI Desktop currently consists of 2 excel sheets that are linked by a relationship (m:n) with double-sided cross-filter direction. The common criterion is the “...
Need Help
  • calerof's avatar
    calerof
    7 years ago

    Hi HT123 ,

     

    Here are the data & pbix sample files.

     

    Data sample

     

    pbix

     

    Cheers,

     

    Fernando

     

HT123's avatar
HT123
Frequent Visitor
7 years ago

HI Fernando,

I don't think I explained my problem properly. Here again the actual situation presented wisely

Here are my 2 Excel Sheets, the relation and the visual

 

 

The bar chart is intended to show the sum per month. The quantity is correctly displayed. Unfortunately, time is wrong. There should be a time a month of 4 coming out not 20! Is this somehow possible??
I would still need a relation from Table 1 Column "Date" to Table 2 Column "Date."

 

 

 

 

calerof's avatar
calerof
Impactful Individual
7 years ago

Hi HT123 ,

 

I replicated your sample data, created a date table, and created a dim table for orders like so:

I did not create a relationship between table A & B on Orders, instead I created a relationship of each table with the dim order table above.

I created a simple measure in each table:

Total Qty = SUM('Table A'[Quantity])
Total Time = SUM('Table B'[Time])

This is the result:

Hope it helps!

 

Regards,

 

Fernando

 

  • calerof's avatar
    calerof
    Impactful Individual
    7 years ago

    Hi HT123 ,

     

    Here are the data & pbix sample files.

     

    Data sample

     

    pbix

     

    Cheers,

     

    Fernando

     

    • HT123's avatar
      HT123
      Frequent Visitor
      7 years ago

      Hi calerof ,

       

      Thanks for your quick help. I would have thought that there would be no solution to this.

      The community is a great thing.