Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Groovy66
Frequent Visitor

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

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

Groovy66_1-1702329783222.png

 

 

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

Hi @Groovy66

 

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

vnuocmsft_0-1702359884455.png

 

Use filters:

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

vnuocmsft_1-1702359911006.png

 

Use drill through:

vnuocmsft_2-1702359920467.png

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

vnuocmsft_3-1702359935514.png

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

vnuocmsft_4-1702359945682.png

vnuocmsft_5-1702359955946.png

vnuocmsft_6-1702359962871.png

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

vnuocmsft_7-1702359982417.pngvnuocmsft_8-1702359989538.png

You can use this button to return to page1

vnuocmsft_9-1702359998276.png

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.

 

 

View solution in original post

2 REPLIES 2
v-nuoc-msft
Community Support
Community Support

Hi @Groovy66

 

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

vnuocmsft_0-1702359884455.png

 

Use filters:

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

vnuocmsft_1-1702359911006.png

 

Use drill through:

vnuocmsft_2-1702359920467.png

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

vnuocmsft_3-1702359935514.png

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

vnuocmsft_4-1702359945682.png

vnuocmsft_5-1702359955946.png

vnuocmsft_6-1702359962871.png

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

vnuocmsft_7-1702359982417.pngvnuocmsft_8-1702359989538.png

You can use this button to return to page1

vnuocmsft_9-1702359998276.png

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
Community Champion
Community Champion

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])

 

    • Repeat this for other columns you want to display.
  1. 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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.