Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have Line stacked bar chart in powerbi desktop.
I want to add mean line only on stack two area, Is that possible to do like that ? I added average line for both stacks, I still couldnt able to figure out how to fix that.
Thank you
Solved! Go to Solution.
Hi @Dilantha ,
Try to create a measure like below and then put it into line value field.
Measure =
AVERAGEX ( FILTER ( ALL ( 'Table' ), 'Table'[type] = 2 ), [value] )
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
I will try that,
One other thing, can we do below steps in line and stacked column chart ?
right click on one column --> data point as table
because I cant do that in my visualiation, It an process when only remove the line.
Does that option not avalable in line and stacked column chart ? or is their any necessary steps to continue that.
Thank you
Hi @Dilantha ,
Based on my test, line and stacked column chart doesn't support Data point table in Power BI currently.
You can choose to post your idea on Power BI Ideas platform.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Thank you for the help.
@Dilantha , Not very clear. Can you try Stacked Area. https://www.tutorialgateway.org/stacked-area-chart-in-power-bi/
I have stacked bar chart like this
I added line for total graph amount , but I only need mean number for yellow coloured area. Not from total values. How can I do that ?
Hi,
Share some data and show the expected result in a simple table format.
Thats the expected visualization,
If we consider thats the data table , i need to display line for only type 2 data. Is that possible to do without measure or with measure ?
can you provide measure example ?
Thank you
Hi @Dilantha ,
Try to create a measure like below and then put it into line value field.
Measure =
AVERAGEX ( FILTER ( ALL ( 'Table' ), 'Table'[type] = 2 ), [value] )
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
I wanted dynamic average line, but this is worked. I changed AVERAGEX --> AVERAGE .
It works fine.
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |