Stacked, Clustered Column and Line Chart Visual

[Ibrahim_shaik]

Hello Power Bi Community,

I want to create a Stacked, Clustered Column and Line Chart Visual.

the issue is all the three columns appear as stack column in the visual but my requirement is two should be in stack and the other column should in the cluster(adjacent to it) for the same timestamp. when i drill down to per day then it is as per my requirement. why it doesn't show the same for per hour as well And when i select two days in the slicer it sums up and shows the data but I want per day data individually when i select more than 1 day.

I created a template with the sample data it worked. but when i trying to create with the actual data, i am facing this issue.

I have attached few screenshots for reference.

 please suggest a solution.

Thanks,

Ibrahim.

[Shaurya]

Hi @Ibrahim_shaik,

Try the following steps:

1. Import your data into Power BI.
2. Create a new Clustered Column Chart.
3. Add your timestamp to the Axis field.
4. Add the Stack1 and Stack2 values to the Values field.
5. Add the Cluster value to the Values field. Ensure it’s displayed as a separate series (not stacked).
6. Add the Line value to the Secondary Values field to display as a line chart.

Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI  

[Ibrahim_shaik]

Hi @Shaurya ,

Thank you for the response.

Can you please share a sample pbi file so that i get a clear understanding. 

[Shaurya]

@Ibrahim_shaik Sure...do you have a sample dataset?

[Ibrahim_shaik]

okay,

I will share a sample dataset.