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 in Power BI by hacke
• 120 points
181 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 by Gitika
• 51,880 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,410 points
67 views
0 votes
2 answers
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
• 32,490 points
134 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 20, 2019 in Power BI by avantika
• 1,500 points
226 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,500 points
417 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
• 32,490 points
173 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,970 points
166 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 51,970 points
145 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 in Power BI by Gitika
• 51,880 points
730 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 in Power BI by anonymous
• 51,880 points
18 views