March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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.
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.
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.
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.
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.
Sorry, just misunderstood.😅 Give me some time.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
86 | |
69 | |
61 |
User | Count |
---|---|
140 | |
121 | |
108 | |
99 | |
96 |