Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

POWER BI DAX Classification on Measure and Measures as Visual Legend

Hi Experts,

I'm trying to build below kind of visual as an output, but visual legend setting is not taking measure.

 


Basically, I was created a conditional measure based on below condition and trying to add this measure as visual Legend.

If Users had only one Unique session Id in a specified date range, then 1 Time
If Users had Two Unique Session Id's in a specified date range, then 1+ Times
If Users had Three Unique Session Id's in a specified date range, then 2+ Times
If Users had More than Three Unique Session Id's in a specified date range, then 3+ Times


And also if the user choose a date range in b/w months like from 15-Aug-2022 to 14-Sep-2022, the graph will still show two bars for each month, but the data must be filtered on the specified date range only.

Please check and let me know if you find any other solutions. I've attached a sample .pbix file for your convenience.

https://drive.google.com/file/d/15Uvha9SUvYf5LOJeor2IAe8Hv6Be8VgR/view?usp=share_link

 

 

Regards,
Rommala

 

 

 

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Team,
    We were able to solve this by using disconnected table like below. 

    and created the following Measure 

    Session Count (w Range) =
VAR _MinRange = MIN( 'Range Table'[MIN] )
VAR _MaxRange = MAX( 'Range Table'[MAX] )
RETURN
    IF( [SessionCount] >= _MinRange && [SessionCount] <= _MaxRange,
        [SessionCount],
        BLANK() )

    and I added Range (from the new table) to your table visual

    For chart, I created this measure (note that it relies on the measure above)

    Unique Count = 
COUNTX( VALUES( data[USERRANK] ), [Session Count (w Range)] )

    and I added the Range column as the chart legend

     

    Regards,

    Anonymous

     

5 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous ,

     

    As per my knowledge, you can't move a measure to the LEGEND section of the visual. It has to be Column.

    Unfortunately, you will have to create a calculated column rather than the measure as shown above; and then use it in the LEGEND section of your visual.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Pragati11,
    I can not create a calculated column, because I need to apply condition on aggregate value. 

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      3 years ago

      HI Anonymous ,

      What happens when you move this value to the y-axis section of your chart rather than in the legend?

      Also can you share a screenhot around what fields you have moved to your chart?

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Team,
    We were able to solve this by using disconnected table like below. 

    and created the following Measure 

    Session Count (w Range) =
VAR _MinRange = MIN( 'Range Table'[MIN] )
VAR _MaxRange = MAX( 'Range Table'[MAX] )
RETURN
    IF( [SessionCount] >= _MinRange && [SessionCount] <= _MaxRange,
        [SessionCount],
        BLANK() )

    and I added Range (from the new table) to your table visual

    For chart, I created this measure (note that it relies on the measure above)

    Unique Count = 
COUNTX( VALUES( data[USERRANK] ), [Session Count (w Range)] )

    and I added the Range column as the chart legend

     

    Regards,

    Anonymous