Forum Discussion
Value conditional formatting
I have a long list of KPIs. Some are percentages but shown as numbers e.g. 12% is shown as 12 - The value is 12 not .12, which is fine. A fair few of the KPIs are curency values.
The individual KPIS are selected from a slicer.
Data is displayed in a clustered column chart with labels turned on
Is there any way of formatting the labels so that for currency KPIs the label is shown as currency e.g. £10,200 with no decimal points whilst for percentage values the data is shown with no symbol but to 1 decimal point e.g. 14.2
I am thinking of maybe some kind of helper column in the KPI list table.
Any suggeations/pointers please?
Hi Fusilier2
You can use field parametrs + conditional formatting with dax .
Please refer to the linked video guide :
https://www.youtube.com/watch?v=KOeT9Dsk-xo&t=11s+
blog post that shared by amitchandakhttps://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
7 Replies
Hi Fusilier2
It sounds like what you're asking is possible, but to give a more accurate answer, it would be helpful to see exactly what your setup looks like and what you're trying to achieve.
If you could share a sample of the data or a mock-up of the expected result (including how the slicer interacts with the chart), I’d be happy to suggest a more specific solution.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi,
So, this is the slicer with a % KPI selected:
The chart will display the values as this:
Which is fine.
If I now select a curency KPI:
The chart shows thus:
In this case I would want to see the label displayed as say £383 etc.
This is how the tables are linked:
I was thinking of some kind of helper column in the definition table but not sure how to use that. Any ideas?
Hi Fusilier2
You can use field parametrs + conditional formatting with dax .
Please refer to the linked video guide :
https://www.youtube.com/watch?v=KOeT9Dsk-xo&t=11s+
blog post that shared by amitchandakhttps://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Fusilier2,
Thank you for reaching out to the Microsoft fabric community forum. Has your issue been resolved? If the response provided by the community member Ritaf1983, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!
Hi Fusilier2,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi Fusilier2,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
