cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ma20114294
Frequent Visitor

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.

Ma20114294_0-1670409088712.png

 


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.

Ma20114294_1-1670410041880.png

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

 

 

 

1 ACCEPTED SOLUTION
Ma20114294
Frequent Visitor

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

Ma20114294_2-1670695975625.png

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

Ma20114294_3-1670696213175.png

 

Regards,

@Ma20114294

 

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

You may download my solution workbook from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ma20114294
Frequent Visitor

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

Ma20114294_2-1670695975625.png

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

Ma20114294_3-1670696213175.png

 

Regards,

@Ma20114294

 

Ma20114294
Frequent Visitor

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

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?

 

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Pragati11
Super User
Super User

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.

 

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Top Solution Authors