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 everyone,
I am a new BI user and I have having trouble with a graph.
I have a datasheet with four columns.
Each column is named Letter 1, Letter 2, Letter 3 and Letter 4.
In each column a date is insert depending if a Letter 1, 2, 3, 4 was sent. Therefore each row (which represents users) will have either no date, 1 date or 2 dates etc.
The data is like this:
I need the graph to show the no. of letters and type of each letter (Letter 1, 2 etc) for each date.
Can anyone help please?
Thanks @v-jiascu-msft Dale but (unless I did something wrong) this didnt work. Maybe it has to do that there are other data in the datasheet also?
I have uploaded a mini example of the datasheet https://files.fm/u/nvnb8bgz in case you want to get a better understanding.
Thanks Dale but (unless I did something wrong) this didnt work. Maybe it has to do that there are other data in the datasheet also?
I have uploaded a mini example of the datasheet https://files.fm/u/nvnb8bgz in case you want to get a better understanding.
Hi, @Zen
Share the link where I can download your data file to help with the solution.
Hello @Rfranca,
I can't share the excel because it includes private data but i have prepared a mini example. https://files.fm/u/nvnb8bgz
Please note that the real excel has a lot more columns and more data. Also (in case it makes any difference) there are cells that are empty.
I need a graph to show how many Letter's 1, 2, 3, 4 were sent for each day (in specific date may be none, in another a couple of 1's and a couple of 2's in other 3' only and so on) and if possible total Letters 1,2,3 and 4 per month.
I appreciate your time and hope you are able to help with this.
Hello Rfranca,
I can't share the excel because it includes private data but i have prepared a mini example. https://files.fm/u/nvnb8bgz
Please note that the real excel has a lot more columns and more data. Also (in case it makes any difference) there are cells that are empty.
I need a graph to show how many Letter's 1, 2, 3, 4 were sent for each day (in specific date may be none, in another a couple of 1's and a couple of 2's in other 3' only and so on) and if possible total Letters 1,2,3 and 4 per month.
I appreciate your time and hope you are able to help with this.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |