Default value to chart

Question

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.&nbsp;&nbsp;&nbsp;

baskar · Answer

Hi, Two things u have to check dude.&nbsp;1. &nbsp;Have to check the relationship with that date slicer and Visual dimesion column .&nbsp;2. &nbsp;have to check the interaction of Date slicer .&nbsp;like the below image&nbsp;&nbsp;&nbsp;

satish_kumar · Answer

Baskar&nbsp;I already done with that too.I hope we got my point what i want to do.

baskar · Answer

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 · Answer

BaskarThis report&nbsp;used only one sheet so i haven't need any relation for that.

bettercallfrank · Answer

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?

Forum Discussion

Default value to chart

7 Replies

Related content

bookmark default value

Expanding tree chart altogether as default.

Default Value 0

default pie chart value setting

Changing Axis values in Bar chart and Legend values in Pie chart on a live connection