Default value to chart

[Satish_Kumar]

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 my reports,

and when i apply filter which is common for all charts the result of my chat which has defualt filter will show the result from the default value which i given to that and the filter(common) applied. 

[Baskar]

Hi, Two things u have to check dude.

1.  Have to check the relationship with that date slicer and Visual dimesion column .

2.  have to check the interaction of Date slicer .

like the below image 

[Satish_Kumar]

@Baskar 

I already done with that too.

I hope we got my point what i want to do.

[Baskar]

The only thing we have to check in Realrionship, pls do that . or else share the relation ship on modelling i will help u

[Satish_Kumar]

@Baskar

This report used only one sheet so i haven't need any relation for that.

[BetterCallFrank]

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]

@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]

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