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

Hi, I must be doing something differently than you. Your example clearly shows this working. I have the following DAX expression defined:

MAUcardTitle = IF ( COUNTROWS ( VALUES ( 'MAU Rollups'[YearMonthDisplay] ) ) > 1, MIN ( 'MAU Rollups'[YearMonthDisplay] ) & " - " & MAX ( 'MAU Rollups'[YearMonthDisplay] ) , MIN ( 'MAU Rollups'[YearMonthDisplay] ) )
 
Also, if I add COUNTROWS ( VALUES ( 'MAU Rollups'[YearMonthDisplay] ) ) to the TRUE side if the IF statement, I see 13, always. Even when one column is selected. 
 
I am always seeing 2018-08 - 2019-08. Even when I click on a single month (any month in the stacked chart). 
The value displayed on the card does change appropriately as I click on and off of different columns in the stacked chart. It's just the title that I cannot yet change dynamically. It's strange because I can clearly see your example is working, and it is using COUNTROWS
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Rees ,

    I found your date values are stored in text type, some of DAX functions can't work properly with text values. (min/max works on numeric or date type)
    Please modify your filed type to 'date', then my measure formula can extract corresponding values.

    Regards,

    Xiaoxin Sheng

    • Rees's avatar
      Rees
      Frequent Visitor
      6 years ago

      Unfortunately that solution does not work. I am simplifying the issue in order to help eliminate possible causes. 

      The following DAX expression results in "A + B" all the time, even when one column is clicked on (focused/selected). 

      IF ( COUNTROWS ( VALUES ( 'MAU Rollups'[YearMonthDisplay] ) ) > 1, "A + B" , "JUST ONE" )


      This matches what I found earlier, that no matter if one column is selected, or not, COUNTROWS always returns 13 (the number of columns). In your example, unless I'm missing it, your COUNTROWS statement returns different values when a single column is clicked on

      I think the problem may be the can the problem be the data model? It is a direct query, that always returns 13 records?