Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Helper V
2 years ago

Stacked, Clustered Column and Line Chart Visual

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...
Need Help
Show and Tell
Tips and Tricks
Shaurya's avatar
Shaurya
Memorable Member
2 years ago

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's avatar
    Ibrahim_shaik
    Helper V
    2 years ago

    Hi Shaurya ,

     

    Thank you for the response.

     

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

    • Shaurya's avatar
      Shaurya
      Memorable Member
      2 years ago

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

      • Ibrahim_shaik's avatar
        Ibrahim_shaik
        Helper V
        2 years ago

        okay,

         

        I will share a sample dataset.