Forum Discussion

Kaly999's avatar
Kaly999
New Member
2 years ago
Solved

Require help in plotting a chart

Hello this is Kalyan. I am new to PowerBI.  I am trying to plot this data into charts of the visual types shown below with those respective filters.                    ...
Need Help
Show and Tell
Tutorial Requests
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Kaly999 
    You can achieve  the desired result by using separate measures for every group, field parameter, and "generated manually " legend

     

     

    The measures that you will need:

    Value A-1 = CALCULATE(sum('Table'[Value A]),'Table'[Parameter]="Parameterl")
    Value A-2 = CALCULATE(sum('Table'[Value a]),'Table'[Parameter]="Parameter2")
    Value B-1 = CALCULATE(sum('Table'[Value b]),'Table'[Parameter]="Parameterl")
    Value B-2 = CALCULATE(sum('Table'[Value b]),'Table'[Parameter]="Parameter2")
    After creating the measures you can create and modify filed parameters:

     

    Then you need to add a calculated column for parameters that will be used at the slicer :

    Parameters = if('Parameter'[Parameter]="Value A-1" ||'Parameter'[Parameter]="Value B-1", "Parametr1","Parametr2")

    The next steps are on the visuals :

    1. Put the parametrs column on the slicer:

    2. On the graph put a date on the axis , the parameter of measures ( not the same column that we took to the slicer ) on the Y-Axis 

    Modify the colors :

    create a legend i did it with shapes and text boxes, you can design it much better on PowerPoint and add it as an image

    group the construction and put it on the legend to the original legend of the gra[h with 4 values (make sure that the generated legend has a background color)

    Pbix is attached

     

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Kaly999 
    Unfortunately, there is no other option, because we don't have a functionality of conditional formatting for colors at the line chart.

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Kaly999 
You can achieve  the desired result by using separate measures for every group, field parameter, and "generated manually " legend

 

 

The measures that you will need:

Value A-1 = CALCULATE(sum('Table'[Value A]),'Table'[Parameter]="Parameterl")
Value A-2 = CALCULATE(sum('Table'[Value a]),'Table'[Parameter]="Parameter2")
Value B-1 = CALCULATE(sum('Table'[Value b]),'Table'[Parameter]="Parameterl")
Value B-2 = CALCULATE(sum('Table'[Value b]),'Table'[Parameter]="Parameter2")
After creating the measures you can create and modify filed parameters:

 

Then you need to add a calculated column for parameters that will be used at the slicer :

Parameters = if('Parameter'[Parameter]="Value A-1" ||'Parameter'[Parameter]="Value B-1", "Parametr1","Parametr2")

The next steps are on the visuals :

1. Put the parametrs column on the slicer:

2. On the graph put a date on the axis , the parameter of measures ( not the same column that we took to the slicer ) on the Y-Axis 

Modify the colors :

create a legend i did it with shapes and text boxes, you can design it much better on PowerPoint and add it as an image

group the construction and put it on the legend to the original legend of the gra[h with 4 values (make sure that the generated legend has a background color)

Pbix is attached

 

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly