Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
20% will be used for category 1,... 100% for category 5,
Hi @tomas12344 ,
Picking up on this you just need to make some adjustments to your visuals:
Donut Chart
If you place the donut chart in front of the card and set the background to off on the donut chart it will work has expected:
2. For the 100% stacked chart you can use a combo chart of Line and column then create a measure to calculate the percentage for columns and use the other measure for the lines, then changing the options on the data labels you can show the result has you need.
On the values of the bottom not really sure if I understand what you need but you can add a matrix visualization with that count:
This is inverted but is just a proof of concept
The last part you should use a condittional formatting, you can define the transparecy using a syntax similar to this one:
"#FFFFFF00"
Where the first 6 digits are for the colour and the last two for the level of transparency. Depending on the way you have everything setup you can do a condittional formatting using a table, but again depends on your setup.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI Miguel
Thanks for the answer. The first part was help. But for the conditional formating, i think this will not work. the conditional formating is working, only when the categories are set to axis (i found many other stream with this problem). When i'm using the legend, the conditional formatig disaper. The second thimg is, that i want to have all the values in one chart column, not 5 columns, when using the categories on axis. Is there any other solution.
Thanks
Tomas
Hi @tomas12344,
I had the feeling that you would get some issues on condittional formatting that is why I added it without examples has I did for the other visualizations. One workaround can be to create a measure for each of your five categories and then use them on the charts and make the selection of the colour per each measure.
Then using a HEX calculator you can check what are the colours corresponding to those 20% decreasein each one.
I have also did a post with a calculation using a disconnected table (it's in portuguese but google translator works preety well)
https://pbiportugal.com/2021/02/04/graficos-com-varias-colunas-como-legendas/
I don't understand is the part that you say:
@tomas12344 wrote:
The second thimg is, that i want to have all the values in one chart column, not 5 columns, when using the categories on axis. Is there any other solution.
Thanks
Tomas
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Miguel
The data for the last chart are simple, there is a date column and answer(satisfaction of customer of the service)
Interview End Date qCSatlabelbar_1
2020-11-01 5
2020-11-01 3
2020-11-01 3
2020-11-02 4
2020-11-02 4
2020-11-02 2
2020-11-02 4
2020-11-03 4
the chart should looks like this
i have used 100% stacked chart, with valuse and legend. the date is not relevat(should cover all historical answers)
Yes, the color can be set by each category, it is litle bit not practical, and the colorpicker is not so usefull.
Hi @tomas12344 ,
This chart type cannot have condittional formatting based on the legend or more than one measure. Believe that to have this visualization with a custom colour you need to use the colour picker.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI @tomas12344,
AFAIk, the conditional formatting feature does not work when you enable the legend fields. They will ignore the formatting settings and use the current theme datacolor sets to setting data label colors.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |