How to create a Stacked, Clustered Column and line chart Visual

[Ibrahim_shaik]

Hi Power Bi community,

I want to create  a Stacked, Clustered 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 clear understanding.

please suggest a solution.

Thanks,

Ibrahim.

[Ibrahim_shaik]

Thank you for the response.

No I have not considered Deneb visual, I'll have a look.

Instead of 1 visual for both stacked and clustered column I have created two visuals.

[lbendlin]

Have you considered using a Deneb visual for that?

Make sure your report users are not confused.