Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
3 years ago

Help with trending on cards please

Hello, I was hoping someone could help me please.   I have a column called TYPE and this is filtered by month and then counted. So for example in May, Type A featured 10 times, Type B featured 7 ti...
Need Help
Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
3 years ago

v-jianboli-msft thank you so much for taking the time to reply. 
Apologies, I should have mentioned before, the date is a sperate table called Calendar. Will that still work?

 

Thank you

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Pricey79 ,

 

What does your raw data look like? Does the Calendar table have any relationship with your fact table?

Do you have a slicer in your report that uses data from the Calendar table.

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

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.

  • Pricey79's avatar
    Pricey79
    Icon for Helper V rankHelper V
    3 years ago

    Hi v-jianboli-msft 

    Apologies and thank you for taking the time to reply. I have changed to so its all in one table now. Your DAX returns no syntax errors, however I get blank on the card?