Stacked chart with dates on X-axis

0 votes
Range 20-04-2020 21-04-2020
0-10 10 14
11-20 23 56
21-30 35 9

I have this table for which I want a stacked graph like this: -

As you see I can draw this graph in excel as a 'recommended graph', but cant do it in power bi.

Please help.

Jun 27, 2020 in Power BI by hacke
• 120 points
2,079 views

1 answer to this question.

0 votes

Hi, @Hacke

Regarding your query, you can follow a few steps:

  • Open the PowerBi dashboard and click on GetData and choose your data and click Load.
  • Go to the field section and start slicing accordingly.

  • The first slice by Range in AXIS and in Legend add your Date and value add your numbers data.

  • Now after slicing, go to the Visualization table where you will get to see the Stacked column chart and click that, you will get your desired chart.

answered Jun 30, 2020 by Gitika
• 65,770 points

Related Questions In Power BI

0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,520 points
670 views
0 votes
2 answers

Can I get rid of the grey border on the report visuals with power bi embedded?

It's just a simple css code to ...READ MORE

answered Apr 19, 2020 in Power BI by Prateek Mehta
5,436 views
0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

answered Apr 10, 2019 in Power BI by Cherukuri
• 33,030 points
958 views
0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

answered May 21, 2019 in Power BI by Avantika
• 1,520 points
1,480 views
0 votes
1 answer

How to refresh a gateway running on Azure VM?

You can easily resolve this error by ...READ MORE

answered Jun 10, 2019 in Power BI by Avantika
• 1,520 points
1,313 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
1,303 views
0 votes
1 answer

PowerBI - Actual & Planned Dates on Same X Axis

Yes, you may add two date columns ...READ MORE

answered Feb 15, 2022 in Power BI by CoolCoder
• 4,420 points
1,389 views
+2 votes
1 answer

What are the best practices for creating responsive layouts and custom themes in Power BI reports?

Designing and Developing Custom Themes and Responsiveness ...READ MORE

answered Oct 22 in Power BI by pooja
• 4,690 points
102 views
0 votes
1 answer

How to use play axis in stocked column chart

Hey Katyvin, If you want to use the ...READ MORE

answered Feb 18, 2020 in Power BI by Gitika
• 65,770 points
2,341 views
0 votes
1 answer

Error refreshing dataset with direct query using on-premise gateway connection

What is your data source type? Could ...READ MORE

answered Nov 19, 2020 in Power BI by anonymous
• 65,770 points
1,265 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP