Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a table and graph visual that looks like the following:
I want to be able to do 2 things:
1. Only display the latest row for each distinct F, M and L Names. This is starightforward and I know how to accomplish
2. Using that filtered table, be able to click a row and show the full history of payments for each distinct F, M and L Names
Here is what I have attempted thus far:
1. The table visual uses dataset Table1, the graph visual uses
Table2 = CALCULATEDTABLE('Table1')
2. I created a measure that looks like the following
Measure 2 =
VAR att = SELECTEDVALUE(Table1[F Name])
VAR att_2 = SELECTEDVALUE(Table1[M Name])
VAR att_3 = SELECTEDVALUE(Table1[L Name])
VAR btt = MAX('Table2'[F Name])
VAR btt_2 = MAX('Table2'[M Name])
VAR btt_3 = MAX('Table2'[L Name])
RETURN
IF(ISBLANK(att) && ISBLANK(att_2) && ISBLANK(att_3), 1, IF(att_2=btt_2 && att=btt && att_3=btt_3, 1, 0))
The measure works if I only use F name (att and btt) as the table visual columns I want to filter on, but when I add the M and L Name variables, the measure stops working, please advise
Solved! Go to Solution.
Hi @P_BI_Noob
Do you hope to realize something like this? When selecting a row, the line graph should show the payments of the specific person?
I create a measure [# Payment] to get the latest payment.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
@P_BI_Noob , Create these measure and user
Last Qty = Var _max = maxx(filter( ALLSELECTED(Data1), Data1[M Name] = max(Data1[M Name]) && Data1[F Name] = max(Data1[F Name]) && Data1[L Name] = max(Data1[L Name]) ),Data1[Date])
return
CALCULATE(sum(Data1[payment]), filter( (Data1), Data1[M Name] = max(Data1[M Name]) && Data1[F Name] = max(Data1[F Name]) && Data1[L Name] = max(Data1[L Name]) && Data1[Date] =_max))
Sum Last Qty = sumx(VALUES(Data1[ID]) , [Last Qty])
Latest Date
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Thank you for the response, however I do not believe this fully answers my question. I want the table visual to display the latest payment AND I want the graph visual to display the full history of payments once I select the latest payment from the table visual.
When I select a latest payment from the table visual currently, the graph visual is filtered down to only the latest payment and not the full history of payments
Hi @P_BI_Noob
Do you hope to realize something like this? When selecting a row, the line graph should show the payments of the specific person?
I create a measure [# Payment] to get the latest payment.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Yes this is exactly what I wanted to accomplish, I did not include the date in my original table and thus did not use the latest summary option which led to my problems. Thanks for the example!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
58 |