Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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,

@Anonymous

 

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/
Anonymous
Not applicable

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,

@Anonymous

 

Anonymous
Not applicable

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

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?

 

Best Regards,

Pragati Jain


MVP logo


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 @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.

 

Best Regards,

Pragati Jain


MVP logo


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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors