Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am creating a cluster bar chart utilizing a custom table to drive the clusters in the Axis and a measure using a switch to drive which measure is behind each cluster. I am looking to add an average line or diamond(Excel), last image attached, but running into the can't create an average measure on a measure.
I am also attaching images of my PowerBI graph and its parameters.
GraphRate is a single column table that has a label for each of the Clusters. SentYYYYMM is the date driving each bar in the cluster. GraphDM is the measure that switches the measure used based on the value in GraphRate column. I can put an Average line but it averages across all clusters and not to each cluster. Any help greatley appreciated.
Hi @brennum,
Perhaps you can switch to the line and clustered column chart and write a measure to show the summarize point on the top of the clustered bar. (setting the filter on the current x-axis group to prevent power bi link these points)
If you confused about the coding formula, please share some dummy data and paste it here with table format then we can simply copy them to test.
Regards,
Xiaoxin Sheng
@brennum sorry not sure I can do anything with these details. Good luck. If you cannot put a sample data together to get help, not sure how I can assist. Sorry about that. I hope someone else can take a look and get you over the line.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Appreciate the offer hopefully someone else has been here.
@brennum what DAX measure you are using for average? Provide sample pbix file with expected output might be an easier way to provide a solution for this. Share thru one drive/google drive.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi,
Due to size and sensitivity of the data, I can't share the PBIX.
The Axis is controlled by a table
The legend is a text field from a header table that has a date converted to YYYYMM.
In Values is a Measure that is set to the value of another measure based on measure Graph1m. Graph1m has following logic:
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |