Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 pages in the report and multiple measures can be selected by the user and the selected measures needs to displayed on the matrix. To illustrate an example I have used 3 measures but in the actual report we have more than 10 measures.
Page -1 has a matrix built using field parameters ,multiple measures can be selected by the user.
In Page 2, I have a calculation groups in the Matrix with the same measures as the Page 1 & I also have some Time Intelligence calculations done using calculation items in tabular editor. In this page I use a slicer from the calculation group inorder to select the measures
Is there a way to sync slicers from both pages, one slicer created from the field parameter and one slicer created from calculation groups.
You can also find the sample report and entire use case here.
Any help on this would be great!
Solved! Go to Solution.
Not really sure if I understand what you mean, but believe that you have created the calculation item to do exactly the same thing as field parameters, you can use the period of the calculation item with the field parameters for selection of the measures.
But if you want to have single selection and both the slicers change to the same value that is possible using the advance sync slicers, for this you need to a slicer both slicers on both pages with the setup of advance sync turn on for all slicers. However there is a change on the field parameters table that you need to do.
Add a new column to your field parameters table with the exact same text as you have on the first column, this is needed because when you use the first column you are picking up not only the name but also the table related. So your field parameter would look like this:
Now do the sync slicers:
In this case on both slicers you need to have the same name but the sync fields change turn off.
See the file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix - Sorry, One more question, is it possible to sync a hierarchy slicer the same way ?
I am trying to do the same approach with hierarchy but unfortunately once I use hierarchy in the slicer, it does not sync anymore, even if they have same values.
Field Parameter
Calculation group
@MFelix - Thank you! The solution you mentioned worked for me!
I did try to use the advanced sync option but it wasn't working because I didn't create a calculated column for the Field Parameters.
Not really sure if I understand what you mean, but believe that you have created the calculation item to do exactly the same thing as field parameters, you can use the period of the calculation item with the field parameters for selection of the measures.
But if you want to have single selection and both the slicers change to the same value that is possible using the advance sync slicers, for this you need to a slicer both slicers on both pages with the setup of advance sync turn on for all slicers. However there is a change on the field parameters table that you need to do.
Add a new column to your field parameters table with the exact same text as you have on the first column, this is needed because when you use the first column you are picking up not only the name but also the table related. So your field parameter would look like this:
Now do the sync slicers:
In this case on both slicers you need to have the same name but the sync fields change turn off.
See the file attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |