User Profile
nbufff
Helper I
Joined 4 years ago
User Widgets
Contributions
How to get change the matrix visual column header name dynamically based on slicer
Hi, I stuck on my case by showing matrix visual header name dynamically based on slicer selection. I have a table with below information. I added a slicer to select the version. e.g. if I choose version A. the matrix table will show vs and "Version A" Qty, if I choose version B, the same matrix table will show vs and "Version B" Qty. Pls give a hint how to achieve that? Thanks.Re: How to duplicate value in matrix visual
dharmendars007 Thanks for your advise. I applied your code below it seemed still same as before, could you pls check if I missed something? Sum of Qty Adjusted = VAR GroupBQty = CALCULATE ( SUM ( 'Data'[Qty] ), 'Data'[Line_Name] = "GroupB", 'Data'[VS] = "Team9") RETURN CALCULATE ( SUM ( 'Data'[Qty] )) + IF ( SELECTEDVALUE ( 'Data'[VS] ) = "Team5" && SELECTEDVALUE ( 'Data'[Line_Name] ) = "GroupB", GroupBQty,0)How to duplicate value in matrix visual
Dear Community, I was asked to duplicate some value from one group to other group, it is easy in excel but seemed stuck if that could be used by certain Measure in PBI. My Case: I used below data to generate the matrix table. MAV Date Line_Name VS Qty 12/19/2024 GroupA Team9 5 12/18/2024 GroupA Team9 4 12/19/2024 GroupB Team9 3 12/18/2024 GroupB Team9 2 12/19/2024 AC01 Team 5 1 I need to put the Group B data under Team 9 to Team 5 as yellow high-lighted below. My solution is to filter Group B data from above table and rename VS toTeam 5, save as new table, then use union to join this new table with original table. It works but is there any easy way e.g. set up certain measure to fulfill that? Thanks for help!Re: Show previous date data on matrix table
DataNinja777 , I tried your formual in my case. it works on most data but some data seemed weir. from below screen you can see on 11/21 there's carryover data 52550 which accordig to your method should be 1800 since actually there's no data on that day. There's few other colum also encountered such issue. I also show you the table view screen shot for your reference. Pls kindly advise if I can improve. carryover_mavqty = VAR currentdate=SELECTEDVALUE(Calendar_Table[Date]) VAR previousqty = CALCULATE( MAXX( FILTER( ALL(Calendar_Table), Calendar_Table[Date] < currentdate && NOT(ISBLANK([sum_mavqty])) ), [sum_mavqty] ) ) RETURN IF( ISBLANK([sum_mavqty]),previousqty,[sum_mavqty])Re: Show previous date data on matrix table
DataNinja777 , It works but the situation here little bit complex. we need to by pass the holdaiy and get the date difference between working days. e.g. we don't need to show Nov.2 and Nov.3 but we need to show working day difference from Nov.1 thank for advise.Show previous date data on matrix table
Dear Community, I stuck on issue how to show previous date data on matrix table. I made matrix table showing qty each day from plant A and B. I want to make it as showing in second picture with high-lighting the part in yellow. Basically 11/3 is missing so it needs to be added by using the data from 11/2. Also Plant A 11/6 qty should be from 11/5 and plant B 11/2 data to be from 11/1. How can we make it? Thanks for help!
