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.
We are developing HR dashboard and have 2 columns in table "Promotion" and "Promotion to Leadership". Since this is promotion table, value for Promotion = Yes in all rows but "Promotion to Leadership" = Yes or No. I want to combine them for legend so that Legend will show values as Promotions and Promotions to Leadership separately in line chart.
Please help with DAX.
Solved! Go to Solution.
Thanks for reply Amit.
That looks like another way but I found if clause syntax and tried it -
@lokeshb31 , You need to have a table (say flag) with values yes and no, Join both columns with this. One join will be inactive. That you can activate using userelationship
Thanks for reply Amit.
That looks like another way but I found if clause syntax and tried it -
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |