The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an area chart. The x-axis is year, Month, Day, hour, minute. That means 1440 data point per date. When user selects date Range for 1 months, you could image user has to roll many many time to even roll over 1 day of data. User cares the trend and not necessary care actual data of every minute. If user want to get detail of the exactly data in a given minute, the default Tooltips do the job already
Is there a way I can "narrow" or compact the chart so it show more datapoint? I don't want to skip datapoint to loss any data.
F.
Hi @fushan ,
If your customer care the trend and not necessary care actual data of every minute, I think they could drill up the hierachy level from minute to up levels like hour or day.
For reference:
Drill down and drill up in a visual - Power BI | Microsoft Docs
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rico . thanks for suggestion. That is not idea. The Y-axis value is base on minute ( average amount per minute ). if drill up, the y-axis value becomes SUM of all 60 average amount per min. That seems not really make sense for me.