How to get Timestamp on X axiis-On Clustered and Stack Bar chart

[ashicool_10061]

HI There,

I am trying to create  a column and Line bar chart like in excel  in which. I am having a datecolumn with TimeStamp and i want a view like below 

Data :

Expected Result: If date is of Today, then only show time interval of today like(1:00 am, 2:00 am,3:oo am) based on starttime column. If date is of yesterday then it will show data for yesterday and if date if of Last week then it will show data with whole week and if date is of 4 weeks back then it will show week1, week2, week 3 week 4  data in chart 

Can anyone help in achieveing this ?

Thainks,

Ashish

@SamWiseOwl  
@Ashish_Mathur 

[Anonymous]

Hi, @ashicool_10061 

I apologize for not being able to fully understand your question. In response to what you've said about the last four weeks, would it not be desirable to get a result similar to the chart below?

Measure UPT = CALCULATE(SUM('Table'[UPT Hours]),FILTER(ALL('Table'),WEEKNUM([Start Time])=SELECTEDVALUE('Date'[Week])))

What do your charts look like in Excel?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ashicool_10061]

Hi @Anonymous ,

I am sorry if i am not BLW TO MAKE YOU understand . So my requirement is like i have a slicer where if i will selct Today then in my chart only Today's Hoursly data shouls represent. If i will chooose yesterday then yesterday hourly data should represt and if i select one week belore then "last week" all days data should appear and if i selct "4 week ago" then all 4 week data should appear like (week1, week2, week 3, week 4")
My current chart in excel with default look looks like this :


Regards,

Ashish

[Anonymous]

Hi, @ashicool_10061 

The way you expect this output, bookmarks in power bi are better suited than slicers.

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Hope that helps.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ashicool_10061]

Hi @Anonymous ,

Thank you for your response however My requirement is not going to full fill from bookmark.

I need to use a slicer where if i will choose today then data should filter in Chart and shows only Today , if i choose yesterday it will show yesterday , if i will choose last week and it will show all 7 days data and if i will click this month then whole Month data should appear .

My Datecolumn has Timestamp as i need to show Time during Today and Yesterday .

Any Suggestions would be really helpfull.

Thanks,

Ash