Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
jhauff77060
Advocate II
Advocate II

Create a chart showing a mark for each day

‎11-08-2017 03:24 PM

Is it possible to create a chart showing a mark for each day, similar to that shown below (created in Tableau)?

FlowChart.gif

Labels:
Message 1 of 9
1,235 Views
0
8 REPLIES 8
parry2k
Super User
Super User

‎11-08-2017 03:42 PM

what is the value for mark? What define the color?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 9
1,231 Views
0
jhauff77060
Advocate II
Advocate II
In response to parry2k

‎11-08-2017 03:50 PM

The formula below was used to create the "Flow Status" field (dimension) in Tableau.

 

IF [Flow Hours] = 24 THEN "Full Flow" ELSEIF [Flow Hours] > 0 THEN "Transition" ELSEIF [Flow Hours] = 0 THEN "Shut-in" ELSE "No Report" END

 

The Flow Status field was then placed on the marks card and colored red/yellow/green based on the result (Full Flow/Transition/Shut-in).

Message 3 of 9
1,227 Views
0
v-chuncz-msft
Community Support
Community Support
In response to jhauff77060

‎11-15-2017 01:58 AM

@jhauff77060,

 

You may take a look at Rule-based conditional formatting for table and matrix.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 9 of 9
1,157 Views
0
parry2k
Super User
Super User
In response to jhauff77060

‎11-08-2017 04:19 PM

seems like you can month on x axis, what is on y axis



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 4 of 9
1,218 Views
0
jhauff77060
Advocate II
Advocate II
In response to parry2k

‎11-09-2017 09:14 AM

In Tableau:

The Prod Date is on the X axis (exact date, continuous).

The Well Name is on the Y Axis.

The Flow Status (Full Flow/Transition/Shut-in) is on the color mark.

 

Does Power BI support anything like this?

FlowHours.gif

Message 5 of 9
1,201 Views
0
jthomson
Solution Sage
Solution Sage
In response to jhauff77060

‎11-09-2017 09:28 AM

You might need a custom visual - scanning the options something like Heat Streams could work for you perhaps. Not sure whether this can be done out of the box

Message 8 of 9
1,191 Views
parry2k
Super User
Super User
In response to jhauff77060

‎11-09-2017 09:23 AM

not sure, but if you share sample data in excel thru google drive or so, will try it



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 6 of 9
1,195 Views
0
jhauff77060
Advocate II
Advocate II
In response to parry2k

‎11-14-2017 07:51 AM

Parr2k - Thanks for offering to help. An Excel spreadsheet with sample data can be found here.

Message 7 of 9
1,173 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All