Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI - Line Chart under Matrix

Hello All,

 

We have requirement to create a below chart in Power BI in which we have a matrix consists of Segment(s) e.g. Hardware, Software, Network, Service, Cloud & AI & Purchasing Dates. Under this matrix, We have line trends with respect to each date & respective segment. 

 

Is it possible to create such chart in Power BI. If yes, how to create it. If not. suggest any alternatives.

 

Thanks,

PBI V2

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    Thanks for your quick reply.

    Based on your consideration, you can try the folloing solution.

    Create a line chart, then put the date to x-axis, and put the value to the y-axis, then put the product to small multiples.

     

    Then in properities, set the column of small miltiples to 1.

     

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

    In the matrix, it cannot implement the visual like this, but you can consider to use the custom visual to implement the similar visual.

    Download the custom visual 'multiple sparklines'

     

    Then put the following field to the visual.

     

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello Anonymous ,

       

      Thanks for your respose. It will fulfill our requirement. Following are the question(s) on this visual.
      1) Is this visual is free or need to buy some license

      2) How to know whether it is approved visual by our organization.

      3) Is it possible to create the required chart by using R or python visual

       

      Thanks,

      PBI V2

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

        Thanks for your quick reply.

        Based on your consideration, you can try the folloing solution.

        Create a line chart, then put the date to x-axis, and put the value to the y-axis, then put the product to small multiples.

         

        Then in properities, set the column of small miltiples to 1.

         

        Output

         

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.