Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have exemplary Line and Column Chart added to my report.
1. X shows car showrooms as ID, like 876 or 978.
2. Bar shows sales car by model.
What I would like to see here also:
1. The line which shows the number of sales model (not total sales of all sales car by model). So for example black means (based on the legend) Tesla X, so it should shows the 1 on the above line, then 2, again 2, and finally 1.
2. When I hover the mouse on that for example black bar then it should show the total sales of Tesla X model.
3. When I click on that value of the number of sales model it should show me the table with details below. I have already created the table on the bottom of my report, but it must works when I select some value on the line. It is important to see that table when I click on the value, not on the bar, since as you can see, the second bar has two model, so I am not able to select whole bar, but only for example blue, or pink. That's why it should shows two rows in my table with all details when I select the number on the line.
4. Ommit those car showrooms ID on the X line where there was not any sold car model. Just imagine the fourth bar (or rather car showrooms ID) without any sales but present on that chart, which I do not want to see. Only those where are any sales.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |