Forum Discussion

Davidglol123's avatar
Davidglol123
New Member
4 years ago

Data Last Year not shown when using a filter for Locations?

Hi Power BI Forum, I have used tremendous time on figuring out how to solve this issue. I have a Date Dim and a fact table, where I related the fact dates into date Dim. Therefore, I can filter us...
Need Help
Tips and Tricks
  • Davidglol123's avatar
    Davidglol123
    New Member
    4 years ago

    Hi Amit,

     

    right now I have my date table single to many into my fact table. Aint that correct?

     

    thanks!

    • v-jingzhang's avatar
      v-jingzhang
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Davidglol123 

       

      Did you use the [CO2_Green_KPI] measure for the line? Can you show the DAX for the measure [[CO2_Per_Kg]]? In addition, you need to use the Dim Location's location column in the slicer, and create a one-to-many relationship to the location in Fact table. 

       

      Best Regards,
      Community Support Team _ Jing