Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all.
I am struggling with a metric which should be easy, but I do not know why it is not showing the information.
I have a table with the connection status of multiple entities. Each row means a connection status per day per entity, as a sample:
Entity Code | DATE | Connection Status |
1 | 11-08-19 | A |
2 | 11-08-19 | A |
3 | 11-08-19 | B |
1 | 11-08-20 | A |
2 | 11-08-20 | B |
1 | 12-08-20 | B |
2 | 12-08-20 | C |
1 | 01-09-20 | A |
2 | 01-09-20 | B |
3 | 01-09-20 | C |
So I have 4 graphs based on the status showing the total amount and compared with other years. As an example, for Status A:
Nevertheless now I would like to show it in % of the total that month. So I have created the next metric:
Solved! Go to Solution.
I had the visual filtered. Once removed the filter it starts to work.
I had created one metric for each status.
I had the visual filtered. Once removed the filter it starts to work.
I had created one metric for each status.
@Chavas , Not very clear. Can you share sample data and sample output in a table format?
refer if this can help https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Sure, first thing first. There was a Typo, now it is showing all as 1
Sample of table:
Entity Code | DATE | Connection Status |
1 | 11-08-19 | A |
2 | 11-08-19 | A |
3 | 11-08-19 | B |
1 | 11-08-20 | A |
2 | 11-08-20 | B |
1 | 12-08-20 | B |
2 | 12-08-20 | C |
1 | 01-09-20 | A |
2 | 01-09-20 | B |
3 | 01-09-20 | C |
My bad...
God, visual filter was applying to the measure that is why it was not working propery.
So, is anyway that I can avoid hardcoding the Filter on the metric and set it on the visual?
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |