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.
Hello,
I have a table like this one:
Transformer DAY KVA%
1 15102017 80
1 16102017 40
1 17102017 60
2 15102017 40
2 16102017 20
2 17102017 100
3 15102017 60
3 16102017 100
3 17102017 120
4 15102017 140
4 16102017 70
4 17102017 90
5 15102017 10
5 16102017 20
5 17102017 90
I created a new table, adding a new column
Table = ADDCOLUMNS(SUMMARIZE(Transformer,Transformer[Transformer],"Average of KVA",AVERAGE(Transformer[KVA%])),"range",SWITCH(TRUE(),[Average of KVA]>80,"KVA% >80",[Average of KVA]<=50,"KVA%<=50","50<Average of KVA%<=80"))
But I have a date slicer, that would like to take into account in the table created. How should I do? Should I filter the summarize by DAY of the transfomer table?
In addition, I would like to change the switch function to values that an user can set like a filter
SWITCH(TRUE(),[Average of KVA]>x,"KVA% >x",[Average of KVA]<=y,"KVA%<=y","y<Average of KVA%<=x")
How this X and Y needs to be set in the report?
Thanks
@Anonymous wrote:
Hello,
I have a table like this one:
Transformer DAY KVA%
1 15102017 80
1 16102017 40
1 17102017 60
2 15102017 40
2 16102017 20
2 17102017 100
3 15102017 60
3 16102017 100
3 17102017 120
4 15102017 140
4 16102017 70
4 17102017 90
5 15102017 10
5 16102017 20
5 17102017 90
I created a new table, adding a new column
Table = ADDCOLUMNS(SUMMARIZE(Transformer,Transformer[Transformer],"Average of KVA",AVERAGE(Transformer[KVA%])),"range",SWITCH(TRUE(),[Average of KVA]>80,"KVA% >80",[Average of KVA]<=50,"KVA%<=50","50<Average of KVA%<=80"))
But I have a date slicer, that would like to take into account in the table created. How should I do? Should I filter the summarize by DAY of the transfomer table?
In addition, I would like to change the switch function to values that an user can set like a filter
SWITCH(TRUE(),[Average of KVA]>x,"KVA% >x",[Average of KVA]<=y,"KVA%<=y","y<Average of KVA%<=x")
How this X and Y needs to be set in the report?
Thanks
@Anonymous
If you'd like the percentages in the Pie chart, it is not possible to set dynamic x&y. Because a fixed axuliary table has to be created in advance.
As to the date slicer, I don't get your question, could you be more specific?
Thanks.
In the sample that you made, I just created the auxiliary table attached.
with a mesure COUNT = COUNTROWS(FILTER('Table','Table'[range]=MAX('Table'[range])))
I want that if I chose a day the pie chart is calculated considering the day selectionned (now calculate all days). I tried to add the day into auxiliary "Table" but it is not correct as count by day.
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 |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
2 | |
2 | |
2 |