Forum Discussion

Rees's avatar
Rees
Frequent Visitor
6 years ago

Stacked Column Chart Linked to Card

Hello, I am pretty new to PowerBI. I have a dashboard (not created by me) that has a stacked column chart showing total user count per month for the past 13 months. There is also a card showing the t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Rees ,

Actually, the highlight effect is similar to normal filter, you can use dax functions(allselected/values, min/max) to get current selection.

Sample title measure:

title measure =
IF (
    COUNTROWS ( VALUES ( 'Table'[Date] ) ) > 1,
    MIN ( 'Table'[Date] ) & " - "
        & MAX ( 'Table'[Date] ) & " sales",
    MIN ( 'Table'[Date] ) & " sales"
)

Regards,

Xiaoxin Sheng

Rees's avatar
Rees
Frequent Visitor
6 years ago

I don't know if you were able to see my results on this suggestion. I can see in your example that it is working. Unfortunately, in mine it is not. I believe I recreated everything you did. I believe the cause is that the Return from COUNTROWS is always the total number of columns shown in the Stacked Column Chart. So, even when highlighting a single chart by clicking on it, the data changes, but the title stays the same because the result from COUNTROWS is always 13.

Do you have any idea why that might be?