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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
andrjohns
Helper I
Helper I

Allowing blank/null for numeric setting - only works online?

Hi All,

 

Bit of an odd one. I have some numeric setting fields which default to blank to imply automatic handling (e.g., if the user does not specify a y-axis upper limit, then it is automatically determined from the data):

andrjohns_0-1695729549482.png

With corresponding `capabilities.json` entry:

andrjohns_1-1695729619047.png

 

When working with the visual in the PowerBI service, it has no issues allowing users to add and remove values.

 

But when working in PowerBI Desktop, if a user adds a value and then tries to remove it, then an error is displayed until a number is entered:

andrjohns_2-1695731449379.png

 

But it can be dismissed by resetting all settings to defaults:

andrjohns_3-1695731511282.png

 

Is this something that should be working/allowed?

 

Alternatively, is there a recommended way to handle optional/blank/null numeric values?

 

Thanks!
Andrew

 

 

0 REPLIES 0

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors