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.
Hi,
I have created a Histogram and Normal distribution curve in Power BI. I want to show the Mean value in the graph.
I have created a below formula:
So when the Mean_age value matches with ''DISTRIBUCION NORMAL'[X]', it shows the f(x) value in the 'μ' column else return '0' as below:
but when I select any value from the filter, the mean value gets changed but in the 'μ' column, its not changing.
Please see the below example,
here, I selected, Emp Id 1 and 2, the mean value is: 14 but in the bar it's still showing as 29. It is not considering the filter selection and comparision is not happening.
still showing value for 29 in the data as well.
Does anyone have idea about this? Am I missing anything?
Thanks in advance.
Solved! Go to Solution.
@Rinku21 are you adding μ as column, it should be measure:
μ = IF(MAX('DISTRIBUCION NORMAL'[X])=ROUND([Mean_Age],0),[f(x)],0)
Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
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.
@Rinku21 are you adding μ as column, it should be measure:
μ = IF(MAX('DISTRIBUCION NORMAL'[X])=ROUND([Mean_Age],0),[f(x)],0)
Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
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 @parry2k ,
Is there any way we can show 'Mean_Age' on the Data label? Currently, it is not showing the Mean value (14) on the label.
@Rinku21 it should if you have data labelled turned on.
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.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |