The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am creating reports on Power BI and need one help on the below query. It's related to Matrix and conditional formatting. We want to display the arrows (downwards / upwards) as per selected columns and not as compare to previous columns. Its working fine when comparison is done with previous columns but when we select the the particular columns the arrows are not shown as expected.
In attached image the column C shows upward arrow because its higher as compare to column B but when we select column A and Column C it should have shown downward arrow.
Much appreciated for all your help. Thanks
I tried with table format , condtional formatting , Dax function for comparison, cumulative function, Bar graph
@aastha93shah , use offset with allselected (Not all) and create a measure to work with previous value and then use icon conditional formatting
refer
Continue to explore Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
User | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
61 | |
51 | |
51 |