Create different line charts according to different subcategories

[Anonymous]

I'm currently creating Power BI's line charts. First, I'm required to create a matrix which contains several information below:

(1) the "row" is the category, then the subcategory is the index number. 

(2) the "values" are total PO values 

I want to achieve a condition such that when I click on the index number under the category. For instance, index is 577899 under the category A, I'll have a line chart such that X axis is a series of unique document numbers under the same index number 577899, then I have corresponding PO values, which are at the Y axis. 

Note that: Index number may be identical or maybe different because a product can be purchased at different times but the document number is unique. In the table view, each document number has a corresponding PO value. 

Here is a test data create for you:

Category	Index number	Document number	PO values
A	566	4776995	$10000
B	123	4776996	$12138
A	566	4776997	$5232
C	798	4776998	$111
D	1119	4776999	$7892
B	478	4777000	$1111
B	478	4777001	$892
D	555	4777002	$333
C	793	4777003	$123

[Thejeswar · Accepted solution]

@Anonymous ,

This is very straight forward.

First build a matrix as you need. shown below ss

Then build a line chart as you want

Now set edit interaction option from matrix to filter the line chart as shown below

Click on the matrix -> click edit interaction -> selection filter in line chart

Now if you click something in matrix, the below line chart will filter only for those documents. In the below snippet Index no 566 is clicked. Line chart gets filtered.

I would prefer having a bar chart for the documents, as line is usually used with trends

Regards,

[Sergii24 · Accepted solution]

Hi @Anonymous, if I understood you correctly you want to achieve something similar to this:

So when you click on item in matrix, the line chart is filtered accordingly. However, you want the chart to appear only when an element in matrix is selected. Is it correct? If so, I don't think you can easily ahcieve the desired result (well, you can play around with line chart background transparency but some elements of it might still be visibile. In addition, you'll need to keep a dedicated space for line chart even when it's blank). You might obtain a similar result by using a tooltip (learn more about it here: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips and Power BI report page tooltip - How to create one in Power BI Desktop)

Here is a result, when you hover the mouse on matrix value:

If you like this approach, consider the following:

• I suggest to add "Index number" as a part of X-axis hierarchy, because you might hover on a cell with more than 1 index:

• I agree with @Thejeswar, using bar chart might be better in your case (because your POs are not connected in time, therefore connecting them with line could bring confusion)

Therefore, your final version could be like this:

You can find sample pbix attached. 

Good luck with your project!

[Thejeswar · Accepted solution]

@Anonymous ,

This is very straight forward.

First build a matrix as you need. shown below ss

Then build a line chart as you want

Now set edit interaction option from matrix to filter the line chart as shown below

Click on the matrix -> click edit interaction -> selection filter in line chart

Now if you click something in matrix, the below line chart will filter only for those documents. In the below snippet Index no 566 is clicked. Line chart gets filtered.

I would prefer having a bar chart for the documents, as line is usually used with trends

Regards,