- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Power BI How to Create Dynamic Conditional Column in matrix visual
Hi All,
I have a matrix visual having some columns and measures-in-a-row:
In a master data table, there are several columns, displaing Group_Discounts based on the year.. Meaning that 2024,2025,...2030 years have differennt discount rates for each company.
I have created a measure that shows the "% Rate" for each quater based on the year chosen in slicer (Green Arrow Direction)..
Qtr Sales Bonus Var =
VAR ChooseYear=SELECTEDVALUE(DateKey[Year])
VAR Leader=SELECTEDVALUE(C_CLIENTS[Client_Group])
RETURN
SWITCH(TRUE(),
ChooseYear=2024,LOOKUPVALUE(Companies_Sales_Plan[2024_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
ChooseYear=2025,LOOKUPVALUE(Companies_Sales_Plan[2025_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
ChooseYear=2026,LOOKUPVALUE(Companies_Sales_Plan[2026_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
ChooseYear=2027,LOOKUPVALUE(Companies_Sales_Plan[2027_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
ChooseYear=2028,LOOKUPVALUE(Companies_Sales_Plan[2028_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
ChooseYear=2029,LOOKUPVALUE(Companies_Sales_Plan[2029_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
ChooseYear=2030,LOOKUPVALUE(Companies_Sales_Plan[2030_Motiv_Qtr],Companies_Sales_Plan[ლიდერის კოდი],Leader),
BLANK())
However, I want to have it kept as a "Dynamic Column" instead of the "Red" marked static column from the master table.
Please advise your solution. So far, I have never tried to create a "Dynamic" column in Matrix visual, thinkin that column is a matrix should be always a static column from the master table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @lbendlin for your prompt reply.
Hi @George1973 ,
May I ask if you have tried the suggestions above? If the suggestion helped you, you might consider marking it as a solution. If the problem has not yet been solved, could you provide more data (excluding private information) so that we can better understand and solve the problem you are experiencing.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unpivot your data in Power Query to bring it into a usable format.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Thanks for your suggestion. I will try, but from this first perspective, I'm not sure that it is a right solution.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
07-01-2024 10:29 AM | |||
Anonymous
| 07-08-2024 09:07 PM | ||
07-18-2024 04:27 AM | |||
01-25-2024 06:53 AM | |||
12-05-2023 03:43 AM |
User | Count |
---|---|
23 | |
12 | |
10 | |
10 | |
8 |
User | Count |
---|---|
16 | |
15 | |
15 | |
12 | |
10 |