cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jch
Microsoft
Microsoft

Categorical Variable in X and Y Axis?

I would like to plot the number of times a DateField value falls within FiscalQuarters, similar to Screenshot 1. An example of the data is in Screenshot 2

 

Screesnshot 1

jch_0-1638197641474.png

 

Screenshot 2

jch_1-1638198450712.png

 

1 ACCEPTED SOLUTION
rsbin
Impactful Individual
Impactful Individual

@jch,

I suggest using a clustered column chart for this.

Fiscal Quarter is your x-axis

Frequency is your Value

DateField is your legend.

This should give you a visual representation of the data you have shown in your Table.

 

Regards,

View solution in original post

3 REPLIES 3
jch
Microsoft
Microsoft

@rsbin  I appreciate the suggestion. The end result turned out a little different than how I'd hoped

jch_0-1638201297207.png

 

@jch , I think this is using Charticulator

 

refer, if these can help

Charticulator Part 1 - Bar and Bar Matrix: https://youtu.be/tKgG0arMaOw

 

if needed

Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI

Charticulator Part 3 - Circular Visual: https://youtu.be/uOaFyg5GsU8

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
rsbin
Impactful Individual
Impactful Individual

@jch,

I suggest using a clustered column chart for this.

Fiscal Quarter is your x-axis

Frequency is your Value

DateField is your legend.

This should give you a visual representation of the data you have shown in your Table.

 

Regards,

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors