cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Animanga008
Helper I
Helper I

How to Create Graph with Measures as X-axis

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 CompanyContract StatusContract Begin DateContract Signed DateContract Freeze DateContract Closed Date
Client-100020Closed8/17/20208/4/2020 10/6/2020
Client-100071Frozen5/24/20211/15/20211/23/2022 
Client-100159Closed5/24/20214/19/2021 10/2/2021
Client-100170Closed2/5/20212/4/2021 8/3/2021
Client-100237Closed12/31/202011/4/2020 3/9/2021

 

Data table with LIVE status:

 

Sub CompanyContract StatusContract Begin DateContract End DateLIVE Status
Client-100020Closed8/17/202010/6/2020Closed
Client-100071Frozen5/24/20211/23/2022Open
Client-100159Closed5/24/202110/2/2021Open
Client-100170Closed2/5/20218/3/2021Open
Client-100237Closed12/31/20203/9/2021Open

 

Now, I need to create a bar chart of a count of these clients, based off of the LIVE status.

1 ACCEPTED SOLUTION
Animanga008
Helper I
Helper I

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 

View solution in original post

1 REPLY 1
Animanga008
Helper I
Helper I

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 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors