Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
(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).
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:
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
Solved! Go to Solution.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
85 | |
65 | |
51 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |