Forum Discussion
Referencing a Specific Cell in Reports
I'm trying to make a bar graph in reports that displays the maximum, minimum, and current value (column header) of a product (row header). I having trouble with this as Power BI is very column centric, always wanting to count or summarize the column when I need a specific value within that culumn. How do I reference a specific cell in reports? I plan to make a graph for each product so it would be great if the solution showed how to make a bunch of graphs at once (perhaps with drill-through), with each graph comparing the same columns but using data from a different row, but if this is too complicated I could always do each rows graph by hand.
- Anonymous6 years ago
Sure,
Click the Bar chart icon.
Then drag the following columns into the Axis and values buckets. Use the little arrow to select, "Min" on Critically Low, "Max" on Excess, then "Average" on Current inventory.
you can download the Power BI file from here if that helps
https://1drv.ms/u/s!AnIEh6WhI4JogrAkH5H_JLNggD6MFg?e=QGHEa2
5 Replies
- AnonymousNot applicable
Are you able to share/ show some sample data?
- AnonymousNot applicable
Only columns A, E, F, and G would be used.
- AnonymousNot applicable
- AnonymousNot applicable
Yes, that's exactly what I was looking for! Would you mind sharing with me the steps taken to make this? I'm not familiar with use of the Axis field.
- AnonymousNot applicable
Sure,
Click the Bar chart icon.
Then drag the following columns into the Axis and values buckets. Use the little arrow to select, "Min" on Critically Low, "Max" on Excess, then "Average" on Current inventory.
you can download the Power BI file from here if that helps
https://1drv.ms/u/s!AnIEh6WhI4JogrAkH5H_JLNggD6MFg?e=QGHEa2