Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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,
@Anonymous
Hi,
You may download my solution workbook from here.
Hope this helps.
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
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?
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
79 | |
58 | |
35 | |
34 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |