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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
DanThompson
Regular Visitor

Parameters & Line-Graph Hierarchy Retain Position

Good morning, 

 

Looking for a little bit of help - first time poster.

I have a project for which I have created two sets of field parameters. 

 

The parameters are "Calendar Year" and "Financial Year". 

They are linked to a data dimension table, with one set of parameters linking to the 'month' columns and the second set of parameters linking to the 'year' columns. 

 

I have created a relationship between the parameter names and have one slicer which displays "Financial Year" / "Calendar Year". 

I have a line graph which displays both the linked year & linked month on the x-axis. 

DanThompson_0-1695291145565.png

(Both SelectedYear and SelectedMonth are text types). 

I have tested and this works fine, however, when the parameter is changed, by default the line graph reverts to the highest level (ie. the year). 

DanThompson_4-1695291424967.png

 

 

If I press the "expand all down one level in the hierarchy" button, then the graph displays as I would like it to - split by month / year:

DanThompson_3-1695291402243.png

 

However, importantly, when I change the parameter - this defaults back to the first level in the hierarchy. 

 

I have tried bookmarks but can't seem to get that to work either.

 

Is there any way to set this visual to display with the expanded hierarchy as default? 

 

Thank you

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

not currently.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

View solution in original post

2 REPLIES 2
DanThompson
Regular Visitor

Thank you for your help @lbendlin, will do.

lbendlin
Super User
Super User

not currently.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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