Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi, I have a table visual with one column for category values such as:
Paid Within 1 Week
Paid Within 2 Weeks
Paid Within 3 Weeks
These values come from a dimension table. I am trying to add in a switch measure similar to the below:
Measure = SWITCH(SELECTEDVALUE(dimPaidWeek[Group]),
"Paid Within 1 Week",[% Paid Within 1 Week],
"Paid Within 2 Weeks",[% Paid Within 2 Weeks],
"Paid Within 3 Weeks",[% Paid Within 3 Week])
The problem is that nothing shows in the table. If I add the individual measures to a card visual they show as expected and if I replace the measure within the switch measure with a hardcoded value it displays. Any help is appreciated.
I got a similar Issues. Is there no solution for this? Or even a best practice how it should be done?
I Documented my approach including the question here
hi @Turambar
It could be your visual elements, like columns, rows, axis are also filtering the measure.
could you make a screenshot of your table visual?
I can't take a screenshot but all visual, page, and repot level filters are turned off.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.