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.
Need help to display the data in the below format.
When ever the measure has a value then need to show a bubble (What ever may be the count) in that particular month.
For the measure 3 we have multiple categories. Each categories are placed in 3 different columns.
Looking for the help or tricks to achive the requirement
This could likely be made with the Charticulator visual, probably also using a calculation group to get a column of measures to be used on your y axis.
(15) Austin Power BI User Group - Charticulator 101 - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat Thanks for your reply!.
Actually my requirement is to plot the measure values in a single line while displaying on X-Axis (what ever the value may be, But the actual value should be displayed in tooltip) and one of my measure has to 3 catagories those three catogories slices the data of that measure only.
Below you can see the sample data and requirment image.
Can you share any thing related to this kind of visualization fulfillment.
sample data.
I can demonstrate how to make your visual with Charticulator, but a few things first.
- Please provide your sample data in a copy/paste-able format (not an image). You can insert a table in your reply and paste your data there.
- Provide a column with category values too, and confirm that it is only Measure 3 that needs to be split by category
- Your x-axis shows as the month but some of the circles appear between month values. Please clarify what your x-axis is. Is each month a mini-axis for your measure values and the circles appear within that space based on the value?
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Table 2
Date | Measure2 |
5/1/2021 0:00 | 1 |
5/2/2021 0:00 | 2 |
5/3/2021 0:00 | 1 |
5/4/2021 0:00 | 3 |
5/5/2021 0:00 | 7 |
5/6/2021 0:00 | 3 |
5/7/2021 0:00 | 3 |
5/8/2021 0:00 | 2 |
5/9/2021 0:00 | 2 |
5/10/2021 0:00 | 5 |
5/11/2021 0:00 | 3 |
5/12/2021 0:00 | 7 |
5/13/2021 0:00 | 1 |
5/14/2021 0:00 | 2 |
5/15/2021 0:00 | 5 |
5/16/2021 0:00 | 3 |
5/17/2021 0:00 | 2 |
5/18/2021 0:00 | 3 |
5/19/2021 0:00 | 4 |
5/20/2021 0:00 | 5 |
5/21/2021 0:00 | 2 |
5/22/2021 0:00 | 6 |
5/23/2021 0:00 | 1 |
5/24/2021 0:00 | 5 |
5/25/2021 0:00 | 6 |
5/26/2021 0:00 | 5 |
5/27/2021 0:00 | 5 |
5/28/2021 0:00 | 7 |
5/29/2021 0:00 | 1 |
5/30/2021 0:00 | 1 |
5/31/2021 0:00 | 4 |
6/1/2021 0:00 | 8 |
6/2/2021 0:00 | 7 |
6/3/2021 0:00 | 4 |
6/4/2021 0:00 | 6 |
6/5/2021 0:00 | 4 |
6/6/2021 0:00 | 2 |
6/7/2021 0:00 | 4 |
6/8/2021 0:00 | 9 |
6/9/2021 0:00 | 10 |
6/10/2021 0:00 | 5 |
6/11/2021 0:00 | 4 |
6/12/2021 0:00 | 2 |
6/13/2021 0:00 | 2 |
6/14/2021 0:00 | 1 |
6/15/2021 0:00 | 10 |
6/16/2021 0:00 | 5 |
6/17/2021 0:00 | 4 |
6/18/2021 0:00 | 3 |
6/19/2021 0:00 | 4 |
6/22/2021 0:00 | 7 |
6/23/2021 0:00 | 7 |
6/24/2021 0:00 | 5 |
6/25/2021 0:00 | 1 |
6/26/2021 0:00 | 2 |
6/27/2021 0:00 | 7 |
6/28/2021 0:00 | 5 |
6/29/2021 0:00 | 9 |
6/30/2021 0:00 | 4 |
7/1/2021 0:00 | 5 |
7/2/2021 0:00 | 7 |
7/3/2021 0:00 | 3 |
7/4/2021 0:00 | 5 |
7/5/2021 0:00 | 3 |
7/6/2021 0:00 | 5 |
7/7/2021 0:00 | 8 |
7/8/2021 0:00 | 6 |
7/9/2021 0:00 | 8 |
7/10/2021 0:00 | 6 |
7/11/2021 0:00 | 1 |
7/12/2021 0:00 | 3 |
7/13/2021 0:00 | 2 |
7/14/2021 0:00 | 4 |
7/15/2021 0:00 | 1 |
7/16/2021 0:00 | 2 |
7/17/2021 0:00 | 4 |
7/18/2021 0:00 | 2 |
7/19/2021 0:00 | 4 |
7/20/2021 0:00 | 4 |
7/21/2021 0:00 | 1 |
7/22/2021 0:00 | 2 |
7/23/2021 0:00 | 3 |
7/25/2021 0:00 | 1 |
7/26/2021 0:00 | 1 |
7/28/2021 0:00 | 1 |
7/30/2021 0:00 | 1 |
8/4/2021 0:00 | 1 |
Thanks for quick responce.
i am sharing the data in the form of tables.
i need to display the count of measure1 and Measure2
Measure count should be catogerized like below one's.
Count of Measure3 for CAT1 =1
Count of Measure3 for CAT2 =1
Count of Measure3 for CAT3 =1.
Thanks in advance for the help
Table 1
Date | Measure1 |
5/1/2021 0:00 | 1 |
5/2/2021 0:00 | 2 |
5/3/2021 0:00 | 1 |
5/4/2021 0:00 | 3 |
5/5/2021 0:00 | 7 |
5/6/2021 0:00 | 3 |
5/7/2021 0:00 | 3 |
5/8/2021 0:00 | 2 |
5/9/2021 0:00 | 2 |
5/10/2021 0:00 | 5 |
5/11/2021 0:00 | 3 |
5/12/2021 0:00 | 7 |
5/13/2021 0:00 | 1 |
5/14/2021 0:00 | 2 |
5/15/2021 0:00 | 5 |
5/16/2021 0:00 | 3 |
5/17/2021 0:00 | 2 |
5/18/2021 0:00 | 3 |
5/19/2021 0:00 | 4 |
5/20/2021 0:00 | 5 |
5/21/2021 0:00 | 2 |
5/22/2021 0:00 | 6 |
5/23/2021 0:00 | 1 |
5/24/2021 0:00 | 5 |
5/25/2021 0:00 | 6 |
5/26/2021 0:00 | 5 |
5/27/2021 0:00 | 5 |
5/28/2021 0:00 | 7 |
5/29/2021 0:00 | 1 |
5/30/2021 0:00 | 1 |
5/31/2021 0:00 | 4 |
6/1/2021 0:00 | 8 |
6/2/2021 0:00 | 7 |
6/3/2021 0:00 | 4 |
6/4/2021 0:00 | 6 |
6/5/2021 0:00 | 4 |
6/6/2021 0:00 | 2 |
6/7/2021 0:00 | 4 |
6/8/2021 0:00 | 9 |
6/9/2021 0:00 | 10 |
6/10/2021 0:00 | 5 |
6/11/2021 0:00 | 4 |
6/12/2021 0:00 | 2 |
6/13/2021 0:00 | 2 |
6/14/2021 0:00 | 1 |
6/15/2021 0:00 | 10 |
6/16/2021 0:00 | 5 |
6/17/2021 0:00 | 4 |
6/18/2021 0:00 | 3 |
6/19/2021 0:00 | 4 |
6/22/2021 0:00 | 7 |
6/23/2021 0:00 | 7 |
6/24/2021 0:00 | 5 |
6/25/2021 0:00 | 1 |
6/26/2021 0:00 | 2 |
6/27/2021 0:00 | 7 |
6/28/2021 0:00 | 5 |
6/29/2021 0:00 | 9 |
6/30/2021 0:00 | 4 |
7/1/2021 0:00 | 5 |
7/2/2021 0:00 | 7 |
7/3/2021 0:00 | 3 |
7/4/2021 0:00 | 5 |
7/5/2021 0:00 | 3 |
7/6/2021 0:00 | 5 |
7/7/2021 0:00 | 8 |
7/8/2021 0:00 | 6 |
7/9/2021 0:00 | 8 |
7/10/2021 0:00 | 6 |
7/11/2021 0:00 | 1 |
7/12/2021 0:00 | 3 |
7/13/2021 0:00 | 2 |
7/14/2021 0:00 | 4 |
7/15/2021 0:00 | 1 |
7/16/2021 0:00 | 2 |
7/17/2021 0:00 | 4 |
7/18/2021 0:00 | 2 |
7/19/2021 0:00 | 4 |
7/20/2021 0:00 | 4 |
7/21/2021 0:00 | 1 |
7/22/2021 0:00 | 2 |
7/23/2021 0:00 | 3 |
7/25/2021 0:00 | 1 |
7/26/2021 0:00 | 1 |
7/28/2021 0:00 | 1 |
7/30/2021 0:00 | 1 |
8/4/2021 0:00 | 1 |
Thank you for providing data, but I am still confused a little. I expected a table of just the values needed for the visual (Month, Measure1, Measure2, Measure3, and Category). I can work with what you sent but I still don't see a Category column. How is that determined from your data? Also, why do some of the data points appear to show between months, suggesting there is more to the x axis that just month name?
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Date | Measure3 | CAT1 | CAT2 | CAT3 |
6/20/2021 0:00 | 13 | 0 | 0 | 0 |
6/20/2021 0:00 | 1 | 0 | 0 | 1 |
6/21/2021 0:00 | 17 | 0 | 0 | 0 |
6/21/2021 0:00 | 1 | 0 | 0 | 1 |
6/21/2021 0:00 | 1 | 1 | 0 | 1 |
6/22/2021 0:00 | 34 | 0 | 0 | 0 |
6/23/2021 0:00 | 21 | 0 | 0 | 0 |
6/23/2021 0:00 | 3 | 0 | 0 | 1 |
6/23/2021 0:00 | 1 | 0 | 1 | 1 |
6/24/2021 0:00 | 26 | 0 | 0 | 0 |
6/24/2021 0:00 | 2 | 0 | 0 | 1 |
6/25/2021 0:00 | 16 | 0 | 0 | 0 |
6/26/2021 0:00 | 17 | 0 | 0 | 0 |
6/26/2021 0:00 | 2 | 0 | 0 | 1 |
6/27/2021 0:00 | 14 | 0 | 0 | 0 |
6/27/2021 0:00 | 3 | 0 | 0 | 1 |
6/27/2021 0:00 | 1 | 0 | 1 | 0 |
6/27/2021 0:00 | 1 | 0 | 1 | 1 |
6/27/2021 0:00 | 2 | 1 | 0 | 1 |
6/28/2021 0:00 | 21 | 0 | 0 | 0 |
6/28/2021 0:00 | 2 | 0 | 0 | 1 |
6/28/2021 0:00 | 1 | 1 | 1 | 0 |
6/29/2021 0:00 | 22 | 0 | 0 | 0 |
6/29/2021 0:00 | 2 | 0 | 0 | 1 |
6/29/2021 0:00 | 1 | 0 | 1 | 0 |
6/30/2021 0:00 | 30 | 0 | 0 | 0 |
6/30/2021 0:00 | 2 | 0 | 0 | 1 |
7/1/2021 0:00 | 21 | 0 | 0 | 0 |
7/1/2021 0:00 | 1 | 0 | 0 | 1 |
7/1/2021 0:00 | 1 | 0 | 1 | 0 |
7/2/2021 0:00 | 26 | 0 | 0 | 0 |
7/2/2021 0:00 | 3 | 0 | 0 | 1 |
7/2/2021 0:00 | 1 | 0 | 1 | 0 |
7/2/2021 0:00 | 1 | 1 | 1 | 1 |
7/3/2021 0:00 | 21 | 0 | 0 | 0 |
7/3/2021 0:00 | 2 | 0 | 0 | 1 |
7/4/2021 0:00 | 17 | 0 | 0 | 0 |
7/4/2021 0:00 | 1 | 0 | 0 | 1 |
7/4/2021 0:00 | 4 | 0 | 1 | 0 |
7/4/2021 0:00 | 2 | 0 | 1 | 1 |
7/5/2021 0:00 | 22 | 0 | 0 | 0 |
7/5/2021 0:00 | 3 | 0 | 0 | 1 |
7/5/2021 0:00 | 1 | 0 | 1 | 0 |
7/6/2021 0:00 | 17 | 0 | 0 | 0 |
7/6/2021 0:00 | 2 | 0 | 0 | 1 |
7/7/2021 0:00 | 31 | 0 | 0 | 0 |
7/7/2021 0:00 | 3 | 0 | 0 | 1 |
7/8/2021 0:00 | 37 | 0 | 0 | 0 |
7/8/2021 0:00 | 1 | 0 | 0 | 1 |
7/8/2021 0:00 | 1 | 0 | 1 | 0 |
7/8/2021 0:00 | 1 | 0 | 1 | 1 |
7/9/2021 0:00 | 28 | 0 | 0 | 0 |
7/9/2021 0:00 | 4 | 0 | 0 | 1 |
7/9/2021 0:00 | 1 | 0 | 1 | 1 |
7/10/2021 0:00 | 23 | 0 | 0 | 0 |
7/10/2021 0:00 | 4 | 0 | 0 | 1 |
7/10/2021 0:00 | 1 | 0 | 1 | 0 |
7/10/2021 0:00 | 1 | 1 | 0 | 1 |
7/11/2021 0:00 | 16 | 0 | 0 | 0 |
7/11/2021 0:00 | 2 | 0 | 0 | 1 |
7/11/2021 0:00 | 1 | 0 | 1 | 0 |
7/11/2021 0:00 | 1 | 0 | 1 | 1 |
7/12/2021 0:00 | 24 | 0 | 0 | 0 |
7/12/2021 0:00 | 4 | 0 | 0 | 1 |
7/12/2021 0:00 | 1 | 0 | 1 | 1 |
7/13/2021 0:00 | 18 | 0 | 0 | 0 |
7/13/2021 0:00 | 3 | 0 | 0 | 1 |
7/14/2021 0:00 | 25 | 0 | 0 | 0 |
7/14/2021 0:00 | 1 | 0 | 0 | 1 |
7/14/2021 0:00 | 1 | 0 | 1 | 0 |
7/15/2021 0:00 | 24 | 0 | 0 | 0 |
7/15/2021 0:00 | 2 | 0 | 1 | 0 |
7/15/2021 0:00 | 1 | 1 | 1 | 0 |
7/16/2021 0:00 | 35 | 0 | 0 | 0 |
7/16/2021 0:00 | 1 | 0 | 1 | 0 |
7/16/2021 0:00 | 1 | 1 | 0 | 1 |
7/17/2021 0:00 | 30 | 0 | 0 | 0 |
7/17/2021 0:00 | 2 | 0 | 0 | 1 |
7/18/2021 0:00 | 17 | 0 | 0 | 0 |
7/18/2021 0:00 | 1 | 0 | 0 | 1 |
7/18/2021 0:00 | 2 | 0 | 1 | 0 |
7/18/2021 0:00 | 1 | 0 | 1 | 1 |
7/18/2021 0:00 | 1 | 1 | 0 | 1 |
7/19/2021 0:00 | 24 | 0 | 0 | 0 |
7/19/2021 0:00 | 1 | 0 | 0 | 1 |
7/20/2021 0:00 | 26 | 0 | 0 | 0 |
7/20/2021 0:00 | 4 | 0 | 0 | 1 |
7/20/2021 0:00 | 1 | 0 | 1 | 1 |
7/20/2021 0:00 | 1 | 1 | 1 | 1 |
7/21/2021 0:00 | 19 | 0 | 0 | 0 |
7/21/2021 0:00 | 1 | 0 | 0 | 1 |
7/22/2021 0:00 | 24 | 0 | 0 | 0 |
7/22/2021 0:00 | 1 | 0 | 0 | 1 |
7/22/2021 0:00 | 2 | 0 | 1 | 0 |
7/22/2021 0:00 | 1 | 0 | 1 | 1 |
7/23/2021 0:00 | 23 | 0 | 0 | 0 |
7/24/2021 0:00 | 21 | 0 | 0 | 0 |
7/24/2021 0:00 | 1 | 0 | 1 | 0 |
7/25/2021 0:00 | 11 | 0 | 0 | 0 |
7/25/2021 0:00 | 3 | 0 | 1 | 1 |
7/26/2021 0:00 | 18 | 0 | 0 | 0 |
7/26/2021 0:00 | 2 | 0 | 0 | 1 |
7/26/2021 0:00 | 1 | 0 | 1 | 1 |
7/26/2021 0:00 | 1 | 1 | 0 | 0 |
7/27/2021 0:00 | 18 | 0 | 0 | 0 |
7/27/2021 0:00 | 1 | 0 | 0 | 1 |
7/28/2021 0:00 | 15 | 0 | 0 | 0 |
7/28/2021 0:00 | 1 | 0 | 0 | 1 |
Thanks for extereme support, i can also convience the user with slight modifications or a near by work around. Based up on your experience can you suggest any other visual where i can visualize the data in power bi.
@Power_Mate .most of the standard visuals you can not have both multiple measure and legend together
Matrix do conditional formatting or icon formatting when every there is values you can have color or icon
you can use measure on row, column month and category
refer if needed
Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
it does not related to conditional formatting. some how i have got the shapes
But the thing is i need to make them uniform on y axis grid even aftering sorting by Month and year.
See the below image
still i need to place all the dots on the single line as shown in the below image
Hi @Power_Mate ,
You want to display the Y-axis value as a static value and the shape as a bubble, in addition to displaying different colors depending on its category. Based on my research, I'm afraid that there is no similar default visual or custom visual that can achieve what you want. Maybe you can raise a new idea and add your comments there to make this feature coming sooner.
Best Regards
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |