Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello community,
I have a dataset and I tried to color the colomns totals only based on a target column so I create a mesure Detla_N+1 and I disabled the row subtotal and finally I create a color mesure.
till now everything is fine. but I descend in row hierarchy , the other values got colored
how do I get rid of coloration ?
thanks in advance.
@Anonymous , what is the column name for month, it should be based on that and Delta_N+1 should be a measure
Color Measure =
VAR QTY =new_df[Delta_N+1]
RETURN
IF(NOT(ISINSCOPE(new_df[Month Name ])),
IF(QTY< 0,"Green","Red"))
indead, it is a measure
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |