Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
asmagh
Helper I
Helper I

change the display of a table report

Hello, if you need your help. Infact, I work with live querry and I created a measurement using a switch. only, this measure is displayed in column while I want to display it online and make a grouping according to the switch that I created while sahching that a customer little in a period have a type of seg_client and when one changes of period it can change type especially I use 2 time filter

the first picture is what i want to have and the second is my result

test2.PNG

 

 

 

 

 

 

 

 

 

 

 

test1.PNG

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @asmagh,

 

Can you share a sample please? It seems you need a DAX formula. Do you mean you want to replace the Seg_client with arrows?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

here the switch that i use to create my measure 
Seg_client  = Switch( TRUE(); [MntPer1] = 0 && [MntPer2]<>0; "new"; 
[MntPer1]<[MntPer2]; "up"; 
[MntPer1]>[MntPer2]; "down" ; 
[MntPer1]<>0 && [MntPer2]=0; "unknown" ; 
BLANK()) 

and i want to change seg_client in rows and also make a regroupment 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors