Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |