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.
I am trying to create a bar chart with measures for the x-axis but can't quite get it.
I have a table of contracts, with their final status and dates associated with those statuses. I have created measures to evaluate the status and return a "LIVE" status as per the parameters of a date slider. To do this, I implement a disconnected tables method.
Data table:
Sub Company | Contract Status | Contract Begin Date | Contract Signed Date | Contract Freeze Date | Contract Closed Date |
Client-100020 | Closed | 8/17/2020 | 8/4/2020 | 10/6/2020 | |
Client-100071 | Frozen | 5/24/2021 | 1/15/2021 | 1/23/2022 | |
Client-100159 | Closed | 5/24/2021 | 4/19/2021 | 10/2/2021 | |
Client-100170 | Closed | 2/5/2021 | 2/4/2021 | 8/3/2021 | |
Client-100237 | Closed | 12/31/2020 | 11/4/2020 | 3/9/2021 |
Data table with LIVE status:
Sub Company | Contract Status | Contract Begin Date | Contract End Date | LIVE Status |
Client-100020 | Closed | 8/17/2020 | 10/6/2020 | Closed |
Client-100071 | Frozen | 5/24/2021 | 1/23/2022 | Open |
Client-100159 | Closed | 5/24/2021 | 10/2/2021 | Open |
Client-100170 | Closed | 2/5/2021 | 8/3/2021 | Open |
Client-100237 | Closed | 12/31/2020 | 3/9/2021 | Open |
Now, I need to create a bar chart of a count of these clients, based off of the LIVE status.
Solved! Go to Solution.
Oof, I have to improve my Google-Fu. The solution to this very often-asked question can be found in this video by RADACAD - DAX Measure in the Axis of the Power BI Report
Oof, I have to improve my Google-Fu. The solution to this very often-asked question can be found in this video by RADACAD - DAX Measure in the Axis of the Power BI Report
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |