Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi, I have two data tables that I'm working with, called 1_Main_Data and 1_Text_Data. I'd like to connect 1_Main_Data and 1_Text_Data.
The tables looks like this:
1_Main_Data:
Value Type (group) | Value Type | Date | Value |
Revenue | Revenue Stream 1 | 12/31/2021 | 100 |
Revenue | Revenue Stream 1 | 3/31/2022 | 110 |
Revenue | Revenue Stream 1 | 6/30/2022 | 115 |
Revenue | Revenue Stream 2 | 12/31/2021 | 700 |
Revenue | Revenue Stream 2 | 3/31/2022 | 710 |
Revenue | Revenue Stream 2 | 6/30/2022 | 720 |
Revenue | Revenue Stream 3 | 12/31/2021 | 5 |
Revenue | Revenue Stream 3 | 3/31/2022 | 20 |
Revenue | Revenue Stream 4 | 6/30/2022 | 25 |
Balance | Account 1 | 12/31/2021 | 1000 |
Balance | Account 1 | 3/31/2022 | 1200 |
Balance | Account 1 | 6/30/2022 | 1300 |
Balance | Account 2 | 12/31/2021 | 2000 |
Balance | Account 2 | 3/31/2022 | 3000 |
Balance | Account 2 | 6/30/2022 | 3400 |
1_Commentary_Data:
Value Type (group) | Forecast Start Period | Text |
Revenue | 12/31/2021 | Stream 1 grew at 5 units per quarter |
Revenue | 12/31/2021 | Stream 3 had highest percentage growth |
Revenue | 12/31/2021 | No revenue Streams had negative values |
Balance | 12/31/2021 | Account balances grew |
Balance | 12/31/2021 | Account 2 had largest percentage growth |
So, both of these tables contain data pertaining to revenues and account balance forecasts. The forecasts begin on the Forecast Period Start Date and continue until 6/30/2022. The 1_Commentary_Data table contains a text column that will be used to display some commentary in a table/matrix.
I have a slicer that shows Value Type (Group) first and then Value Type. These slicer variables are coming from 1_Total_Data. What I want is for the commentary to show up when I select ALL values of a particular Value Type (Group). So, it should be blank if I only select Revenue Stream 1, but if I select Revenue Stream 1, 2, and 3, then it should show all of the Text values in 1_Commentary_Data in a table or matrix.
How can I do this? I don't understand how these tables could be linked in the data model, becuase Revenue or Balance is showing up on every row of Value Type (group), so any selection of a value in that group will give the table the greenlight to show the Text Values. I've also tried a measure, but that won't allow me to pass a table of values to the Table or Matrix visualizations.
Is there any way to do what I want? I would appreciate any insight on this problem. Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Please try below steps
1. my test table
Table:
Table2:
Model:
2. add two slicer visual and add two fields from "Table"
3. create a measure and add it to card visual
Measure =
VAR cur_valuetype_group =
HASONEFILTER ( 'Table'[Value Type (group)] )
VAR cur_valuetype =
HASONEFILTER ( 'Table'[Value Type] )
VAR tmp =
FILTER (
ALL ( 'Table 2' ),
cur_valuetype_group = TRUE ()
&& cur_valuetype = FALSE ()
&& 'Table 2'[Value Type (group)] = SELECTEDVALUE ( 'Table'[Value Type (group)] )
)
RETURN
CONCATENATEX ( tmp, [Text] & ";", "
" )
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please try below steps
1. my test table
Table:
Table2:
Model:
2. add two slicer visual and add two fields from "Table"
3. create a measure and add it to card visual
Measure =
VAR cur_valuetype_group =
HASONEFILTER ( 'Table'[Value Type (group)] )
VAR cur_valuetype =
HASONEFILTER ( 'Table'[Value Type] )
VAR tmp =
FILTER (
ALL ( 'Table 2' ),
cur_valuetype_group = TRUE ()
&& cur_valuetype = FALSE ()
&& 'Table 2'[Value Type (group)] = SELECTEDVALUE ( 'Table'[Value Type (group)] )
)
RETURN
CONCATENATEX ( tmp, [Text] & ";", "
" )
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |