POWER BI DAX Classification on Measure and Measures as Visual Legend

[Ma20114294]

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

[Ashish_Mathur]

Hi,

You may download my solution workbook from here.

Hope this helps.

[Ma20114294 · Accepted solution]

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,

@Ma20114294

[Ma20114294]

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

[Pragati11]

HI @Ma20114294 ,

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?

[Pragati11]

Hi @Ma20114294 ,

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.