Forum Discussion

Emmy66's avatar
Emmy66
Icon for Helper V rankHelper V
5 years ago

Create a table to hold 2 Measures

Hi, I'm trying to create a clustered bar chart where I have 10 measures. My intention is to have 2 of the measures grouped or stored in a table so that there will be spaces between each pair. curre...
Need Help
fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Try this useful trick...  Most Charts in Power BI allow you to assign Multiple VALUES.  Each of these Values will group together simular to what you were looking to make...  

 

Create a Measure of one set of bars (let's say the Purple Lines in your example)

Gropu A = CALCULATE(SUM('Table (2)'[Values]), FILTER('Table (2)', 'Table (2)'[Group] = "A"))
Then create a Second Measure of the other set of Bars (let's say the Green Lines in your example)
Gropu B = CALCULATE(SUM('Table (2)'[Values]), FILTER('Table (2)', 'Table (2)'[Group] = "B"))
 
Here's some sample data I put together, remember BOTH sets of lines have to SHARE a vertical Axis in common.  In this example, we are Grouping (by Color) Group = A or Group = B, but the Shared Axis values have to be in common as well.
And here's the set-up with BOTH Measures in the Values.

 

  • Emmy66's avatar
    Emmy66
    Icon for Helper V rankHelper V
    5 years ago

    Hi fhill , thanks for your response. Very much appreciated. What you illustrated is exactly what I intend to achieve. Like you mentioned, that I should create a measure of one set of bars (how do I accomplish that please?) Currently I have 10 measures that are dynamically calculated (all expressed in %) which I've created e.g. the measures are based on the calculation below.

     

    I have 6 other measures calculated in same manner. The measures with prefix Partners_Only (represents the purple bar) and the prefix All_users (represents the green bar).  With the above measures, how do I implement your suggestion please bearing in mind that the measures are not held in any table but calculated on the fly?
    • fhill's avatar
      fhill
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

      In my example, the 2 Measures have filters of the source data that allow both sets of data to be displayed on the same chart without overlap (Legend). 

       

      It looks like your example measures are DIVIDING other measures?  You'll need to post an example of your source data for us to help you with the actual Measure code.  

       

       

      • Emmy66's avatar
        Emmy66
        Icon for Helper V rankHelper V
        5 years ago

        fhill, please see below my measures used. I hope it helps. Thanks in advance.