Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Form Pictiure Above, If I want Power BI Bar Chart to display only TOP 2 Product of Each Month How Can I Do That From the dataset that I provided.
Thanks
Hi @MoJi,
I'd like to suggest you write a calculated column which used to calculate current row ranking, then use if function to filter it(rank less or equal to 2) and use the calculated column as the value field.
For example:
Dynamic Value= var currRank = formula return if(currRank <=2,[Value Column],blank())
Regards,
Xiaoxin Sheng
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |