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.
Hey! I got a bar chart, x-axis is list of brands, y-axis measure. Looks like this:
(can't show x-acis due to company agreement). I need a measure that will be an average value of y-axis measure by x-axis category. I can calculate this measure:
Solved! Go to Solution.
Hi:
Can you try a Line & Clustered chart, using the overall measure as seconday Y? I'll paste image for more clarity. My example is on profit margin %, but can be done for your overall SAT measure. I hope this helps..
Measure for flat line:
@Gleb just add your measure as a constant line in the analytics tab of the visual formatting :
The answer is correct, very cool. But I should use not constant line, but average line, thanks, I didn't know about these feature.
Hi:
Can you try a Line & Clustered chart, using the overall measure as seconday Y? I'll paste image for more clarity. My example is on profit margin %, but can be done for your overall SAT measure. I hope this helps..
Measure for flat line:
I won't work because let's say your sales in my case is a measure, not a column
Hi:
Can you provide example data (and image of key tables in your data model)as it should be possible to create a measure showing the values you want as a straight line?
Thanks
Table: Both;
Columns: Brand, Person_ID, Question, Answer, answer_code, Type
Measure:
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
32 | |
30 | |
18 | |
18 |