Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi.
I have Date on X-Axis
On Y Axis i have Count of Items
On the line going across I want it to portray count of 1 of 4 possible items.
When i use that filter - the Count of items goes down to the count of 1/2/3/4, I ant Count of Items to be a constant.
Some more details will help to understand your issue. Could you please sahre some sample data with expected output?
Thanks
Raj
Hi Raj.
Thanks for your reply.
So when i select the option in Page Level filter or Report Level filter (tried both)
Both values decrease.
I want the column value to be a constant and the line value to fluctuate depending on the option i choose.
Hope this makes this clearer.
Picture 1 is with all items selected.
Picture 2 is with one of the option only.
I want the Column in picture 2 to remain like in Picture 1.
Whilst the line is "dynamic"
Hi @Dauan ,
Sorry for the delay.
If it is convenient, could you share some data sample which could reproduce your scenario so that I could copy and test in my site.
Best Regards,
Cherry
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 32 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 70 | |
| 38 | |
| 27 | |
| 24 |