Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a column called XYZ in an excel which has the values of 123, 456, 789, OTHER, EXPIRED in each rows respectively. How can i group or convert the (123, 456, 789) as ACTIVE.
Currently Power BI will appear 5 bar charts of 123, 345, 789, OTHER, EXPIRED
When i add a Conditional Column, i do:
If XYZ equals "OTHER" then "Other Partners"
Else if XYZ equals "EXPIRED" then "Expired Contracts:
OTHERWISE "ACTIVE"
And when the Conditional column is created, the ACTIVE is not grouping the (123, 456, 789).
But i would need Power BI to show only 3 bar charts only such as ACTIVE, OTHER, EXPIRED.
Can you please help me how to fix this?
Solved! Go to Solution.
Hello,
Yes Now it's working perfectly.
I'm not able to understand why it did not work or which mistake i did and it was not working.
but after watching your picture, now it's working..
Man thanks a lot. You are genius.
You truly saved my day...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |