cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power_Mate
Frequent Visitor

looking for visualization

Need help to display the data in the below format.

Capture.PNG

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

 

12 REPLIES 12
mahoneypat
Super User
Super User

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI 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.

Power_Mate_2-1631530361980.png

 

 

Power_Mate_1-1631529201477.png

 

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Table 2 

DateMeasure2
5/1/2021 0:001
5/2/2021 0:002
5/3/2021 0:001
5/4/2021 0:003
5/5/2021 0:007
5/6/2021 0:003
5/7/2021 0:003
5/8/2021 0:002
5/9/2021 0:002
5/10/2021 0:005
5/11/2021 0:003
5/12/2021 0:007
5/13/2021 0:001
5/14/2021 0:002
5/15/2021 0:005
5/16/2021 0:003
5/17/2021 0:002
5/18/2021 0:003
5/19/2021 0:004
5/20/2021 0:005
5/21/2021 0:002
5/22/2021 0:006
5/23/2021 0:001
5/24/2021 0:005
5/25/2021 0:006
5/26/2021 0:005
5/27/2021 0:005
5/28/2021 0:007
5/29/2021 0:001
5/30/2021 0:001
5/31/2021 0:004
6/1/2021 0:008
6/2/2021 0:007
6/3/2021 0:004
6/4/2021 0:006
6/5/2021 0:004
6/6/2021 0:002
6/7/2021 0:004
6/8/2021 0:009
6/9/2021 0:0010
6/10/2021 0:005
6/11/2021 0:004
6/12/2021 0:002
6/13/2021 0:002
6/14/2021 0:001
6/15/2021 0:0010
6/16/2021 0:005
6/17/2021 0:004
6/18/2021 0:003
6/19/2021 0:004
6/22/2021 0:007
6/23/2021 0:007
6/24/2021 0:005
6/25/2021 0:001
6/26/2021 0:002
6/27/2021 0:007
6/28/2021 0:005
6/29/2021 0:009
6/30/2021 0:004
7/1/2021 0:005
7/2/2021 0:007
7/3/2021 0:003
7/4/2021 0:005
7/5/2021 0:003
7/6/2021 0:005
7/7/2021 0:008
7/8/2021 0:006
7/9/2021 0:008
7/10/2021 0:006
7/11/2021 0:001
7/12/2021 0:003
7/13/2021 0:002
7/14/2021 0:004
7/15/2021 0:001
7/16/2021 0:002
7/17/2021 0:004
7/18/2021 0:002
7/19/2021 0:004
7/20/2021 0:004
7/21/2021 0:001
7/22/2021 0:002
7/23/2021 0:003
7/25/2021 0:001
7/26/2021 0:001
7/28/2021 0:001
7/30/2021 0:001
8/4/2021 0:001

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

DateMeasure1
5/1/2021 0:001
5/2/2021 0:002
5/3/2021 0:001
5/4/2021 0:003
5/5/2021 0:007
5/6/2021 0:003
5/7/2021 0:003
5/8/2021 0:002
5/9/2021 0:002
5/10/2021 0:005
5/11/2021 0:003
5/12/2021 0:007
5/13/2021 0:001
5/14/2021 0:002
5/15/2021 0:005
5/16/2021 0:003
5/17/2021 0:002
5/18/2021 0:003
5/19/2021 0:004
5/20/2021 0:005
5/21/2021 0:002
5/22/2021 0:006
5/23/2021 0:001
5/24/2021 0:005
5/25/2021 0:006
5/26/2021 0:005
5/27/2021 0:005
5/28/2021 0:007
5/29/2021 0:001
5/30/2021 0:001
5/31/2021 0:004
6/1/2021 0:008
6/2/2021 0:007
6/3/2021 0:004
6/4/2021 0:006
6/5/2021 0:004
6/6/2021 0:002
6/7/2021 0:004
6/8/2021 0:009
6/9/2021 0:0010
6/10/2021 0:005
6/11/2021 0:004
6/12/2021 0:002
6/13/2021 0:002
6/14/2021 0:001
6/15/2021 0:0010
6/16/2021 0:005
6/17/2021 0:004
6/18/2021 0:003
6/19/2021 0:004
6/22/2021 0:007
6/23/2021 0:007
6/24/2021 0:005
6/25/2021 0:001
6/26/2021 0:002
6/27/2021 0:007
6/28/2021 0:005
6/29/2021 0:009
6/30/2021 0:004
7/1/2021 0:005
7/2/2021 0:007
7/3/2021 0:003
7/4/2021 0:005
7/5/2021 0:003
7/6/2021 0:005
7/7/2021 0:008
7/8/2021 0:006
7/9/2021 0:008
7/10/2021 0:006
7/11/2021 0:001
7/12/2021 0:003
7/13/2021 0:002
7/14/2021 0:004
7/15/2021 0:001
7/16/2021 0:002
7/17/2021 0:004
7/18/2021 0:002
7/19/2021 0:004
7/20/2021 0:004
7/21/2021 0:001
7/22/2021 0:002
7/23/2021 0:003
7/25/2021 0:001
7/26/2021 0:001
7/28/2021 0:001
7/30/2021 0:001
8/4/2021 0:001

 

 

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


DateMeasure3CAT1CAT2CAT3
6/20/2021 0:0013000
6/20/2021 0:001001
6/21/2021 0:0017000
6/21/2021 0:001001
6/21/2021 0:001101
6/22/2021 0:0034000
6/23/2021 0:0021000
6/23/2021 0:003001
6/23/2021 0:001011
6/24/2021 0:0026000
6/24/2021 0:002001
6/25/2021 0:0016000
6/26/2021 0:0017000
6/26/2021 0:002001
6/27/2021 0:0014000
6/27/2021 0:003001
6/27/2021 0:001010
6/27/2021 0:001011
6/27/2021 0:002101
6/28/2021 0:0021000
6/28/2021 0:002001
6/28/2021 0:001110
6/29/2021 0:0022000
6/29/2021 0:002001
6/29/2021 0:001010
6/30/2021 0:0030000
6/30/2021 0:002001
7/1/2021 0:0021000
7/1/2021 0:001001
7/1/2021 0:001010
7/2/2021 0:0026000
7/2/2021 0:003001
7/2/2021 0:001010
7/2/2021 0:001111
7/3/2021 0:0021000
7/3/2021 0:002001
7/4/2021 0:0017000
7/4/2021 0:001001
7/4/2021 0:004010
7/4/2021 0:002011
7/5/2021 0:0022000
7/5/2021 0:003001
7/5/2021 0:001010
7/6/2021 0:0017000
7/6/2021 0:002001
7/7/2021 0:0031000
7/7/2021 0:003001
7/8/2021 0:0037000
7/8/2021 0:001001
7/8/2021 0:001010
7/8/2021 0:001011
7/9/2021 0:0028000
7/9/2021 0:004001
7/9/2021 0:001011
7/10/2021 0:0023000
7/10/2021 0:004001
7/10/2021 0:001010
7/10/2021 0:001101
7/11/2021 0:0016000
7/11/2021 0:002001
7/11/2021 0:001010
7/11/2021 0:001011
7/12/2021 0:0024000
7/12/2021 0:004001
7/12/2021 0:001011
7/13/2021 0:0018000
7/13/2021 0:003001
7/14/2021 0:0025000
7/14/2021 0:001001
7/14/2021 0:001010
7/15/2021 0:0024000
7/15/2021 0:002010
7/15/2021 0:001110
7/16/2021 0:0035000
7/16/2021 0:001010
7/16/2021 0:001101
7/17/2021 0:0030000
7/17/2021 0:002001
7/18/2021 0:0017000
7/18/2021 0:001001
7/18/2021 0:002010
7/18/2021 0:001011
7/18/2021 0:001101
7/19/2021 0:0024000
7/19/2021 0:001001
7/20/2021 0:0026000
7/20/2021 0:004001
7/20/2021 0:001011
7/20/2021 0:001111
7/21/2021 0:0019000
7/21/2021 0:001001
7/22/2021 0:0024000
7/22/2021 0:001001
7/22/2021 0:002010
7/22/2021 0:001011
7/23/2021 0:0023000
7/24/2021 0:0021000
7/24/2021 0:001010
7/25/2021 0:0011000
7/25/2021 0:003011
7/26/2021 0:0018000
7/26/2021 0:002001
7/26/2021 0:001011
7/26/2021 0:001100
7/27/2021 0:0018000
7/27/2021 0:001001
7/28/2021 0:0015000
7/28/2021 0:001001

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.

amitchandak
Super User
Super User

@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/

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

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

Power_Mate_0-1631111270003.png

still i need to place all the dots on the single line as shown in the below image

Power_Mate_1-1631111399790.png

 

any tips or tricks to achieve @amitchandak @yingyinr 

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!