Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shmooel
Regular Visitor

Parent -> Child Timeseries line chart

So, I have a dataset with multiple hierarchies (I only provide 3 below as an example but it's more). I want to be able to create a timeseries where if you select something from a Tier it shows all the Children in the Legend or a line for each one and averages the values for those children.

 

So, the x-axis are the dates and the y axis is the average of the values but I can't get the Legend to dynamically shift down to the children relating to that hierarchy. I feel like it somehow combines parameters but just can't seem to get the last bit. I don't want the user to have to select Tier1 or Tier2 but instead because they filtered down to an entity in Tier1 it shows only the related entities in Tier2 in the legend and thus a line for each one; repeat for each hierarchy. When no hierarchy is selected it should show a line for each distinct Tier1 entity.

 

Tier1Tier2Tier31/1/20231/2/20231/3/20231/4/20231/5/20231/6/20231/7/20231/8/2023
TOPAMIDABOT154036428361816
TOPAMIDABOT24752623299119
TOPAMIDABOT3141918927293522
TOPAMIDBBOT133027232920238
TOPAMIDBBOT2312426123218214
TOPAMIDBBOT31810364120223529
TOPBMIDABOT1472564448424343
TOPBMIDABOTA2115491120372810
TOPBMIDCBOTD825429839229
TOPBMIDCBOTB1416381541432832
TOPBMIDBBOT2251427482873929
TOPBMIDBBOT54850391132101947
TOPBMIDBBOT7635036436749
TOPCMIDDBOTT154227341133642
TOPCMIDDBOTO114010413343314
TOPCMIDDBOTP323333210444013
TOPCMIDDBOT31893429639410
0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.