Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I suspect I'm asking a little too much with this but is it possible to apply some form of conditional formatting on the values in a column of a table visual whenever the value in that column changes?
For example, if I have a table that is sorted by an ID column which contains non-unique values (e.g., like an order number) is it possible to write a script that interates through each row in the table visual and changes the font format (e.g., toggles bold) whenever the value changes?
Does the Power BI toolkit/GUI provide a simple mechanism for this?
Essentially, I'm just trying to make it easier to distinguish between different "sets" of data.
As a simple example, if the sample table looks like this:
Ref. | Date | ID (Sorted) | SomeValue1 | SomeValue2 |
001 | 05/06/22 | AAA | ||
002 | 05/06/22 | AAA | ||
003 | 05/06/22 | AAA | ||
004 | 06/06/22 | BBB | ||
005 | 06/06/22 | BBB | ||
006 | 07/06/22 | BBB | ||
007 | 07/06/22 | CCC | ||
008 | 08/06/22 | CCC |
After script execution, the table would now look like this (i.e., boldened font where value in ID changed from AAA to BBB, then non-bold font where value changes from BBB to CCC).
Ref. | Date | ID (Sorted) | SomeValue1 | SomeValue2 |
001 | 05/06/22 | AAA | ||
002 | 05/06/22 | AAA | ||
003 | 05/06/22 | AAA | ||
004 | 06/06/22 | BBB | ||
005 | 06/06/22 | BBB | ||
006 | 07/06/22 | BBB | ||
007 | 07/06/22 | CCC | ||
008 | 08/06/22 | CCC |
Solved! Go to Solution.
Hi @ddalton
This is not possible in Power BI currently. You may raise an idea at Ideas (powerbi.com)
To make it easier to distinguish, maybe you can try the matrix visual. Put all columns in Rows well to have a hierarchy. Then expand it to the lowest hierarchy to show all data. In the format pane, turn off +/- icons and Stepped layout options below Row headers.
Or like this. Put columns which need to be aggregated in Values well. Turn off Column subtotals and Row subtotals.
Ensure to put ID column on the top in Rows well, then one set of ID will be placed together. This is a workaround which is not perfect. And as a matrix is different from a table visual and it behaves differently in some ways, it may not be able to replicate all effects you have already got in a table visual.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @ddalton
This is not possible in Power BI currently. You may raise an idea at Ideas (powerbi.com)
To make it easier to distinguish, maybe you can try the matrix visual. Put all columns in Rows well to have a hierarchy. Then expand it to the lowest hierarchy to show all data. In the format pane, turn off +/- icons and Stepped layout options below Row headers.
Or like this. Put columns which need to be aggregated in Values well. Turn off Column subtotals and Row subtotals.
Ensure to put ID column on the top in Rows well, then one set of ID will be placed together. This is a workaround which is not perfect. And as a matrix is different from a table visual and it behaves differently in some ways, it may not be able to replicate all effects you have already got in a table visual.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thanks, @v-jingzhang
That works really well. As you've noted, you just have to be selective the data row order to make sure you get the preferred view.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |