Forum Discussion
Create data group to simplify visual
- 10 months ago
Hi Anonymous ,
Thanks for reaching out to Microsoft Fabric Community Forum.
Organize Your Formulas/Blocks Efficiently with Field ParametersI have tried this repro on my side and got results. Please check it, and if you encounter any issues, let me know.
Created a simple table
Year Sales Budget
2024 100 120
2025 150 130Created Measures Individually
S_2025 = CALCULATE(SUM(Data[Sales]), Data[Year] = 2025)
Var_S_vs_S_1_2025 = [S_2025] - SUM(Data[Budget])
Var_S_vs_S_2_2025 = DIVIDE([S_2025] - SUM(Data[Budget]), SUM(Data[Budget]))These measures serve as the formulas to be grouped.
Created Field ParametersNavigate to Modeling - New Parameter - Fields.
In the dialog box, select the measures to group:
S_2025
Var_S_vs_S_1_2025
Var_S_vs_S_2_2025
Rename the parameter to Measure Groups and Create. Power BI will generate:
A slicer visual featuring your parameter , new DAX table named Measure Groups.
Added Matrix visual.
Add Year to Rows.
Include the Measure Groups field parameter in Values.
This setup allows dynamic grouping and switching between blocks. Maintenance is straightforward, simply update the field parameter when new measures are introduced.
Hi Anonymous ,
Thanks for reaching out to Microsoft Fabric Community Forum.
Organize Your Formulas/Blocks Efficiently with Field Parameters
I have tried this repro on my side and got results. Please check it, and if you encounter any issues, let me know.
Created a simple table
Year Sales Budget
2024 100 120
2025 150 130
Created Measures Individually
S_2025 = CALCULATE(SUM(Data[Sales]), Data[Year] = 2025)
Var_S_vs_S_1_2025 = [S_2025] - SUM(Data[Budget])
Var_S_vs_S_2_2025 = DIVIDE([S_2025] - SUM(Data[Budget]), SUM(Data[Budget]))
These measures serve as the formulas to be grouped.
Created Field Parameters
Navigate to Modeling - New Parameter - Fields.
In the dialog box, select the measures to group:
S_2025
Var_S_vs_S_1_2025
Var_S_vs_S_2_2025
Rename the parameter to Measure Groups and Create. Power BI will generate:
A slicer visual featuring your parameter , new DAX table named Measure Groups.
Added Matrix visual.
Add Year to Rows.
Include the Measure Groups field parameter in Values.
This setup allows dynamic grouping and switching between blocks. Maintenance is straightforward, simply update the field parameter when new measures are introduced.
Hi Anonymous ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
- v-sshirivolu10 months agoCommunity Support
Hi Anonymous ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you