Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

Default value to chart

Hi All, I am having a problem in my report as the challenge given to me, In my report i have to put a default filter on my chart i.e. which will not effected by the filter which is common for all m...
Need Help
BetterCallFrank's avatar
BetterCallFrank
Icon for Resolver IV rankResolver IV
9 years ago
Seems like you're using time intelligence functions without a gapless date table in your model then. Time intelligence functions will need such a table to work properly.
Do you have such a table with relationship and all measures using the date table?
Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

BetterCallFrank

No, actually i am using only one table for that report so i hav'nt created any kind of that relationship that you are talking.

  • BetterCallFrank's avatar
    BetterCallFrank
    Icon for Resolver IV rankResolver IV
    9 years ago

    Hi Satish_Kumar,

    ok, that's what I thought from what you've mentioned.

    I further assume that your measures are using time intelligence functions which will not work properly without a gapless date dimension/table in your model.

     

    Can you post the DAX formulas of your measures?

     

    Also, if you can share the PBIX file somewhere it will be very helpful.

     

    All the best,

    Frank