Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a requirement where I have to add a total bar to a bar graph but it should be visible only when 2 or more values are selected in the slicer. Otherwise when only one value is selected it should show only that bar.
It should look like the below screenshots.
Regards,
Vanshika
Solved! Go to Solution.
@Vanshikaw14 OK, I was able to do it using the following measure coupled with a disconnected table. See PBIX attached below signature.
Measure =
VAR __Tiers = DISTINCT( 'Table'[Tier] )
VAR __Count = COUNTROWS( __Tiers )
VAR __ShowTotal = IF( __Count > 1, TRUE(), FALSE() )
VAR __Tier = MAX( 'Tiers'[Tier] )
VAR __Result =
SWITCH( TRUE(),
__Tier IN __Tiers, SUMX( FILTER( 'Table', [Tier] = __Tier ), [Value] ),
__Tier = "Total" && __ShowTotal, SUMX( 'Table', [Value] ),
BLANK()
)
RETURN
__Result
@Vanshikaw14 OK, I was able to do it using the following measure coupled with a disconnected table. See PBIX attached below signature.
Measure =
VAR __Tiers = DISTINCT( 'Table'[Tier] )
VAR __Count = COUNTROWS( __Tiers )
VAR __ShowTotal = IF( __Count > 1, TRUE(), FALSE() )
VAR __Tier = MAX( 'Tiers'[Tier] )
VAR __Result =
SWITCH( TRUE(),
__Tier IN __Tiers, SUMX( FILTER( 'Table', [Tier] = __Tier ), [Value] ),
__Tier = "Total" && __ShowTotal, SUMX( 'Table', [Value] ),
BLANK()
)
RETURN
__Result
@Vanshikaw14 Pretty sure that would require a disconnected table for your x-axis and then a measure that included the logic on whether to return a value or not. I'll see if I can mock it up or perhaps you could post sample data.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |