Dynamically change the signs of numbers in a table.

[POSPOS]

Hi,

I have a requriment to allows different group of users to view the signs of numbers differently in a table.

Eg: I have 5 columns in a table, few users may want to see the first three columns as a positive(+) number and few users may want to see the first three as a negative(-) number. 

Similarly, few may want to see column 2 and 5 as (+) and others as (-). 

It will be different combinations for different users.

Can someone please suggest a way to do this using any custom table visuals?

Note: We do not want to create Bookmarks as there will be different combinations..

Thank you.

[v-mdharahman]

Hi @POSPOS,

Thanks for reaching out to the Microsoft fabric community forum. It looks like you are lookiung for a way for different users to see the sign (+/-) of numbers per column differently in the same table visual. As @danextian, @speedramps and @burakkaragoz all responded to your query, kindly go through their responses and check if your issue can be resolved.

I would also take a moment to thank @danextian, @speedramps and @burakkaragoz, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

[v-mdharahman]

Hi @POSPOS,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround so that other users can benefit as well.  And if you're still looking for guidance, feel free to give us an update, we’re here for you.

Best Regards,

Hammad.

[v-mdharahman]

Hi @POSPOS,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.

Best Regards,

Hammad,

[v-mdharahman]

Hi @POSPOS,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.

Best Regards,

Hammad.

[danextian]

You might be able to do this with conditional dynamic format strings. It would be easier to come up with a solution had you provided a workable sample data (not an image) and your expected result from the same.

[speedramps]

Try this ....

Create some test data

Create a config table of how each user wants to see columns

Create dax for each column

Bought = 
var option = 
CALCULATE(
MIN(Config[Option]),
Config[User] = USERNAME(),
Config[Column] = "Bought"
)

var amount = SUM(yourdata[Bought])
RETURN

SWITCH(TRUE(),
option = "Positive", FORMAT(amount,"+#"),
option = "Negative", FORMAT(amount,"-#"),
amount
)

Sold = 
var option = 
CALCULATE(
MIN(Config[Option]),
Config[User] = USERNAME(),
Config[Column] = "Sold"
)

var amount = SUM(yourdata[Sold])
RETURN

SWITCH(TRUE(),
option = "Positive", FORMAT(amount,"+#"),
option = "Negative", FORMAT(amount,"-#"),
amount
)

Test using the "View as role"

Please click thumbs up and [accept as solution]

[burakkaragoz]

Hi @POSPOS 

This is a pretty unique requirement and I couldn't find a standard Power BI visual that handles dynamic sign changes per user out of the box.

Here are your realistic options:

Create DAX measures for each sign combination you need:

Column1_UserGroup1 = [Original Value] * 1    // Positive
Column1_UserGroup2 = [Original Value] * -1   // Negative

Then use a slicer or parameter to let users choose their view. You'd have multiple versions of each column and show/hide them based on selection.

Use a custom table visual like Zebra BI Tables or similar - some of these have more advanced formatting options but I'm not sure any specifically handle dynamic sign switching per user.

Build a custom Power BI visual that handles this logic. This would require development skills but could give you exactly what you need.

Create user-specific reports with different sign configurations, though you mentioned wanting to avoid this approach.

The DAX measure approach with parameters is probably your most practical solution. You'd create measures for each sign combination and use slicers to control which version displays.

Unfortunately, this kind of user-specific numerical formatting isn't something Power BI handles natively. Most formatting options are report-wide, not user-specific.

Have you considered whether there's a business logic reason why different users need to see signs differently? Sometimes addressing the underlying need leads to a simpler solution.

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by I for translation and formatting purposes.