Need help to design Model for Per Second to Year hierarchy Visualization

[Shamsbutt]

I'm working with Big Data, have per second data for some years. Data tables are like TimeStamp, Key, Value

I want to plot heirarchy drill down and up functionality like

Seconds -> Minutes -> Hour -> Day -> Week -> Month -> Quater -> Year.

How can i acheive this.

[Icey]

Hi @Shamsbutt ,

Try this:

Attach my PBIX file.

Best Regards,

Icey

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

[Shamsbutt]

Thanks @Icey ,

I'll accept this as solution.

Can you please help if i add more complexity in heirarchy like, Last 5Min, 15Min, 30Min, 1hr, 2hr, 4hr, 8hr, 1day . . . upto Year.

[Icey]

Hi @Shamsbutt ,

You can create columns like so:

Last 5Min = IF('Table'[Minute]>=55,"Last 5Min")

Last 15Min = IF('Table'[Minute]>=45,"Last 15Min")

And then add them to the Hierarchy.

Best Regards,

Icey

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

[Shamsbutt]

@Icey ,

Why are you checking minute should be >= 55

Last 5Min = IF('Table'[Minute]>=55,"Last 5Min")

[Icey · Accepted solution]

Hi @Shamsbutt ,

What about this?

PBIX file attached.

Best Regards,

Icey

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

[Shamsbutt]

Thanks @Icey 

[Icey]

Sorry, just misunderstood.😅 Give me some time.