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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
FredrikJ
Resolver I
Resolver I

Fx on measures in Pivot table connected to semantic model.

Hi!

 

Why is the Fx symbol on measures in Pivot table connected to semantic model visible and sometimes not? 

 

We have different semantic model with measure tables constructed in the same way but when connected to Excel Pivot tables some of the models shows with the Fx symbol on the measures and not in others.

 

FredrikJ_0-1742290083350.png

 

FredrikJ_1-1742290145271.png

 

Regards 

Fredrik

 

1 ACCEPTED SOLUTION
FredrikJ
Resolver I
Resolver I

Hi!

 

I have found why it differ between different Semantik Models. If the model has unable implicit measure the FX symbol will not show in the Excel Pivot tables.

View solution in original post

3 REPLIES 3
FredrikJ
Resolver I
Resolver I

Hi!

 

I have found why it differ between different Semantik Models. If the model has unable implicit measure the FX symbol will not show in the Excel Pivot tables.

Anonymous
Not applicable

Hi @FredrikJ ,

 

What I'm asking is what kind of software is this?

 

The interface doesn't look like Power BI Desktop, for other software related questions please go to the appropriate forum and ask your question, there will be more professional people there to help you.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Hi! @Anonymous 

 

Yes it is a Power BI Desktop issue. Because it is probably caused by some setting in Power BI Desktop when I create the Semantic Model that we use connected to pivot tables in Excel.

 

Regards

Fredrik

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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
Top Kudoed Authors