Hide weekend from bar chart

[#1]

Hi All,

Can someone please tell me to hide weekends from the barchart as there is no data.

Regards

Krishna

[#2]

Under Properties>Dimension> select your field click on suppress when value is Null

[#3]

Hi Harsha, Thnx for the reply..but the problem is i have no data for weekdays too..my only target is to hide weekends.

I wrote a condition like if(weekday(date)='Sun',hide).. i tried 0 as well its not working ....

[#4]

please tell me for which weekday data is not available & what calculation you trying to achieving after removing null weekday data ...

Try with usde of Use Isnull() ...

[#5]

Hi Harshal,

PFA qvw..

Regards

Krishna !

[#6 · Accepted solution]

hope you want like this please let me know..

PFA,

[#7]

Thnx Harshal..this is wat exactly I wanted ...

Regards,

Krishna