Show rows in new view based on selection (Multiple identical values in Column)

[Anonymous]

Hi,

Struggling with the following. Have below. Where Ref Doc is the Document Flow. 

I want to show in a separate view when I select any line for example with 9999999 that it shows me all the Doc with Qty, Value.

And when I select 8888888 only those 2 lines.

The data itself has millions of rows and linked to this Fact Table there are other Dimension fields I want to pull in as well

A direction in which I should take this is Highly appreciated.

Thanks in advance

Stefan

[Anonymous · Accepted solution]

Hi @Anonymous

I know you want to display the data in a new view by selecting Ref Doc, here I give you a few ways to do it:

Use Slicer:

Add a slicer to select the Ref Doc

Use filters:

add the Ref Doc to the “Add data fields here”

Use drill through:

First, create a visual and select Ref Doc as the column, open the “Cross-report”

Add a visual on page 2 and select columns what you need, add the Ref Doc to the “Add drill-through fields here”

Now, you can get the content you want with Drill Through in page1

You can use this button to return to page1

Best Regards,

Nono Chen

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

[123abc]

Here's a general guide on how you might approach this:

Method 1: Using Visual-Level Filters

1. Create a Table or Matrix Visual:

   • Add a table or matrix visual to your report.
   • Drag the necessary columns, including "Ref Doc," "Qty," "Value," and other dimension fields you want to display, into the Values or Rows section of the visual.

2. Set Visual-Level Filters:

   • Select the table or matrix visual.
   • In the Visualizations pane, find the "Filters" section.
   • Drag the "Ref Doc" field from your data table into the "Filters" section.

3. Configure the Filter:

   • Choose the values you want to display (e.g., 9999999 or 8888888).
   • Click "Apply filter" or press Enter.

This method will dynamically filter the visual based on the selected Ref Doc.

Method 2: Using Measures and Slicers

1. Create a Measure:

   • Create a new measure using DAX. For example:

SelectedRefDoc = SELECTEDVALUE('YourTable'[Ref Doc])

1. Create a Table or Matrix Visual:

   • Add a table or matrix visual to your report.
   • Drag the necessary columns, including "Ref Doc," "Qty," "Value," and other dimension fields you want to display, into the Values or Rows section of the visual.

2. Create a Slicer:

   • Add a slicer to your report.
   • Drag the "Ref Doc" field from your data table into the slicer.

3. Filter Using DAX Measure:

   • Modify your visual using DAX measures. For example:

FilteredQty = CALCULATE(SUM('YourTable'[Qty]), 'YourTable'[Ref Doc] = [SelectedRefDoc])

1. • Repeat this for other columns you want to display.

2. Interact with the Slicer:

   • When you select a value in the slicer, it will dynamically update the visual based on the measure.

Additional Notes:

• You may need to adjust these steps based on your specific data model and requirements.
• Ensure that relationships between tables are properly set up.
• Make sure to consider the performance implications, especially if dealing with large datasets.

These methods should give you a starting point for creating a dynamic view based on the selected values in Power BI.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.