Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 64 | |
| 50 | |
| 45 |