Bro .one doubt....I created one bar chart, athu 3pm to 4 pm mattum daily dashboard la show aaganum... remaining time la show aaga kudathu.... How bro? If u have any formula please share bro

Need to create the below measure to show the report during 3 pm to 4 pm IST Show report = var current_time_ist = NOW() + TIME(5,30,0) var Start_Time_ist = DATE(YEAR(current_time_ist),MONTH(current_time_ist),DAY(current_time_ist))+TIME(15, 0, 0) --3PM_IST var End_Time_ist = DATE(YEAR(current_time_ist),MONTH(current_time_ist),DAY(current_time_ist))+TIME(16, 0, 0) -- 4PM_IST Return IF(current_time_ist >= Start_Time_ist && current_time_ist <= End_Time_ist,1,0) drag this measure into visual level filter of your bar chart..then apply the filter like show the items when the value is 1

@@BITechinTamil thank u sooooo much...bro ...I will try.....

Hi.,bro right now I tried this formula ...after created measure, just drag the show report measure to filter pane, then give 1 then automatically bar hide..bro .. then I change the time like 20-21 for 8 pm to 9 pm ( start time ane end time) still the charts not visible......bro....y??? Please say bro....

@@BITechinTamil in first line, y r u adding + time(5,30,0) (var cur_time=now()+time(5,30,0)..... ?? Pls clarify bro

@@samueljabaraj4662 Second IF statement ( order <=1000) will check from 101 to 1000. First IF statement will covers 1 to 100

@@BITechinTamil Okay Nandri👍