Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
As we want alternate colour we will add index column and using that we will add colour columns.
Go to edit queried and add index columns.
Once Index column is added create new column using following DAX function
This will bring 1 and 2 in clront of each row. Once we get this column go to Report Pane and select Bar chart.
Then, in the Format pane go to Data colurs and select connditonal formating option as follows,
Solved! Go to Solution.
"Field Value" more universal and agile approach:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
"Field Value" more universal and agile approach:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
It's easier use field option.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
40 | |
20 | |
12 |