Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello all,
hello @amitchandak
Please I need your help,
I try to create a line in each page of the report allowing me to summarize all the filters selected in a way that the user sees in the head of each page a summary of all the filters selected, as they are many it will not be lost or confused, especially that I intend to hide the filters
example of a goal to be achieved (filter1,fliter2,fliter3,......)
How can i do that ?
thank you so much
user83
Solved! Go to Solution.
@user83 , do you want to concatenate the value and show?
Filter = "Filter 1" & concatenatex(Filter1,allselected(Filter1[Filter1]) & "Filter 2" & concatenatex(Filter2,allselected(Filter2[Filter2])
Hi @user83 ,
Depending on the number of filter/slicers and how they are setup you need to create a measure for example:
Active Filter =
"Date Filter: " & FORMAT ( MIN ( 'Calendar'[Date] ); "dd/mm/yyyy" ) & " to: "
& FORMAT ( MAX ( 'Calendar'[Date] ); "dd/mm/yyyy" )
& UNICHAR ( 10 ) & "Filter One Column: "
& CONCATENATEX (
ALLSELECTED ( 'Table'[FilterOneColumn] );
'Table'[FilterOneColumn];
","
)
In this case I have a date filter that is based an interval so I pick the maximum and minumum date. The Unichar is to get a line break and then I pick all the values on the FilterOneColumn that I select and I concatenat them final result is the one below:
Now you jus need to put it on a card, a table or matrix visualization and setup as you need.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @user83 ,
Depending on the number of filter/slicers and how they are setup you need to create a measure for example:
Active Filter =
"Date Filter: " & FORMAT ( MIN ( 'Calendar'[Date] ); "dd/mm/yyyy" ) & " to: "
& FORMAT ( MAX ( 'Calendar'[Date] ); "dd/mm/yyyy" )
& UNICHAR ( 10 ) & "Filter One Column: "
& CONCATENATEX (
ALLSELECTED ( 'Table'[FilterOneColumn] );
'Table'[FilterOneColumn];
","
)
In this case I have a date filter that is based an interval so I pick the maximum and minumum date. The Unichar is to get a line break and then I pick all the values on the FilterOneColumn that I select and I concatenat them final result is the one below:
Now you jus need to put it on a card, a table or matrix visualization and setup as you need.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@user83 , do you want to concatenate the value and show?
Filter = "Filter 1" & concatenatex(Filter1,allselected(Filter1[Filter1]) & "Filter 2" & concatenatex(Filter2,allselected(Filter2[Filter2])
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |