Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
Michael_Gold
Frequent Visitor

Dynamic Format does not change in graph

‎09-11-2022 09:14 AM

Hello,

 

I created a measure with dynamic data type. When my parameter is set to "%" the value appear as a percentage in the table, and while it's set to "ILS" it appears as a number. The problem is that the graph won't show any data when it's set to "%", everything disappears:

 

Michael_Gold_0-1662912662122.png

 

Any way to handle this? I want my to have one graph and my users to be able to choose between % to number.

I can split it into 2 measures and use bookmarks but I want a 'clean' dashboard

Labels:
Message 1 of 3
688 Views
0
2 REPLIES 2
DataInsights
Super User
Super User

‎09-11-2022 04:11 PM

@Michael_Gold,

 

I believe the issue is due to the FORMAT function converting the data type to text. You could try two approaches:

 

1. Fields parameter (requires two measures; you can format each measure without FORMAT)

2. Calculation group (the "format string expression" applies the specified format without converting the data type to text)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Message 2 of 3
643 Views
0
Michael_Gold
Frequent Visitor
In response to DataInsights

‎09-13-2022 09:45 AM

Hi, thank you for your answer, I will try to use calculatin groups 

Message 3 of 3
617 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All