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.
Hi,
Please help me to build a visual. Here below is the souce data. Service, Usage Date and the Price.
In the report there sholud be one DateFilter and the Stacked Column Chart.
The Stacked Column Chart shows the Total Price by the date.
Here you can observe the
price on Day 03-03-2017 is 21,
price on Day 03-04-2017 is 41,
price on Day 03-05-2017 is 27,
There is sudden icrease in the price from 03-03-2017 to 03-04-2017 and also there is decrease from 03-04-2017 to 03-05-2017
I want to show the services which are made the price high or low. When I Select Column 03-04-2017, I need to show the data in a table like below, (OR Is any other way to do this, please let me know)
Service | UsageDate | Price |
Visual Studio | 3/4/2017 | 20 |
Sql | 3/5/2017 | 10 |
Visual Studio | 3/5/2017 | 12 |
Source Data:
Service | UsageDate | Price |
PowerBI | 3/1/2017 | 10 |
Azure | 3/1/2017 | 5 |
Sql | 3/1/2017 | 6 |
Visual Studio | 3/1/2017 | 12 |
PowerBI | 3/2/2017 | 10 |
Azure | 3/2/2017 | 5 |
Sql | 3/2/2017 | 6 |
Visual Studio | 3/2/2017 | 12 |
Office | 3/2/2017 | 13 |
PowerBI | 3/3/2017 | 10 |
Azure | 3/3/2017 | 5 |
Sql | 3/3/2017 | 6 |
PowerBI | 3/4/2017 | 10 |
Azure | 3/4/2017 | 5 |
Sql | 3/4/2017 | 6 |
Visual Studio | 3/4/2017 | 20 |
Azure | 3/5/2017 | 5 |
Sql | 3/5/2017 | 10 |
Visual Studio | 3/5/2017 | 12 |
PowerBI | 3/6/2017 | 10 |
Azure | 3/6/2017 | 5 |
Sql | 3/6/2017 | 6 |
Security | 3/6/2017 | 10 |
Visual Studio | 3/6/2017 | 12 |
PowerBI | 3/7/2017 | 10 |
Sql | 3/7/2017 | 6 |
Visual Studio | 3/7/2017 | 12 |
PowerBI | 3/8/2017 | 20 |
Azure | 3/8/2017 | 15 |
Thanks.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
111 | |
97 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |