Forum Discussion
Calculated table that responds to context
Hello nicoenz,
Thank you for reaching out to the Microsoft Fabric Forum Community. I have reproduced your scenario in Power BI Desktop as you described.Summary of What I Did:
- I created a disconnected axis table with GENERATESERIES for the X-axis values (0 to 10 million).
- I replaced the calculated table approach with measures that calculate FMC, VMC, and NS dynamically using SELECTEDVALUE from the axis table.
- I built a line chart using this axis table on the X-axis and the measures on the Y-axis.
- I tested with slicers filtering the Product field, and the chart values update dynamically as expected.
This approach meets your requirement to have a fixed number of rows (axis values) that respond to slicer/filter context.
For your reference, I am attaching the .pbix file demonstrating this solution so you can explore or adapt it further.
Thank you, Greg_Deckler for sharing valuable insights.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hello nicoenz,
Thank you for reaching out to the Microsoft Fabric Forum Community. I have reproduced your scenario in Power BI Desktop as you described.
Summary of What I Did:
- I created a disconnected axis table with GENERATESERIES for the X-axis values (0 to 10 million).
- I replaced the calculated table approach with measures that calculate FMC, VMC, and NS dynamically using SELECTEDVALUE from the axis table.
- I built a line chart using this axis table on the X-axis and the measures on the Y-axis.
- I tested with slicers filtering the Product field, and the chart values update dynamically as expected.
This approach meets your requirement to have a fixed number of rows (axis values) that respond to slicer/filter context.
For your reference, I am attaching the .pbix file demonstrating this solution so you can explore or adapt it further.
Thank you, Greg_Deckler for sharing valuable insights.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.