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.
Figure 1.0 - design screen above is shown of my report.
I collected data shown in the table for preference of colors - the results are shown eg. Red, Yellow for the participants in survey.
What I need to acheive:
The horizontal three colors at the top, as shown in the image above, when clicked shouold filter for all rows that contains the selected color.
\Figure 2.0 the tables in the PowerBI
Solved! Go to Solution.
Hi @iping ,
Try this:
Measure 2 =
IF (
SUMX (
ColorTable,
FIND (
UPPER ( ColorTable[ChoiceList] ),
UPPER ( MAX ( ColorsDS[Color Choice] ) ),
,
0
)
) > 0,
1
)
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
This is great.
Muchas Gracia.
Hi @iping ,
Try this:
Measure 2 =
IF (
SUMX (
ColorTable,
FIND (
UPPER ( ColorTable[ChoiceList] ),
UPPER ( MAX ( ColorsDS[Color Choice] ) ),
,
0
)
) > 0,
1
)
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
@iping , On of the way is to split the values using power query into the rows.
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Another way is use and independent slicer table to display color in the slicer and then use search or containsstring
measure =
var _max = selectedvalues(Color[Color])
return
calculate(countrows(colortable),filter(colortable,search(_max,colortable[Color],,0)>0))
refer: https://www.youtube.com/watch?v=mZt0HJw4gjQ
https://www.youtube.com/watch?v=XbgLGDvWdWQ
@amitchandak Thank you for the idea and post. ✌️
The second method using the DAX is preferred. However, what I observe from your online videos for the search function, seem to be that it will only find the text string entered. My results are shown below.
The function work but it will return results only if it says "Red" , while I am seeking to return a result where the work Red can be in a line as follows eg - Green, Red, Yellow or Yellow, Red.
Will look into the ContainString function.
@amitchandak wrote:@iping, On of the way is to split the values using power query into the rows.
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Another way is use and independent slicer table to display color in the slicer and then use search or containsstring
measure =
var _max = selectedvalues(Color[Color])
return
calculate(countrows(colortable),filter(colortable,search(_max,colortable[Color],,0)>0))
refer: https://www.youtube.com/watch?v=mZt0HJw4gjQ
https://www.youtube.com/watch?v=XbgLGDvWdWQ
Covering 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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |