Require help in plotting a chart

[Kaly999]

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. 

 

Kindly suggest me how this can be done. Thanks in advance. 

Kalyan, Hyderabad. 

[Ritaf1983 · Accepted solution]

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

[Kaly999]

Thanks @Ritaf1983  for the solution. 
The solution seems very lengthy one. 

The query i posted earlier is a sample of my actual data. My actual data has 5 Variables & 40 Items.
(in relation with my previous query, Parameters have been replaced with Variables & Values with Items respectively, to avoid confusion with DAX terminology).

(5 Variables including Date)

So here is a snapshot of my expectation / probable solution.

The Variables need to be multiselected. Date can be a single value or a range.

Please suggest/guide me with the approach/steps. 

Thanks in advance

Kalyan

[Ritaf1983]

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