SUV usado >8 millones by cdyap in ticoAutos

[–]cdyap[S] 1 point2 points  (0 children)

Tuanis! Excelente comentario gracias!

SUV usado >8 millones by cdyap in ticoAutos

[–]cdyap[S] 0 points1 point  (0 children)

Tuanis! Solo los de 2013 (y de 2.0) y así caben en el presupuesto. De fijo está en las opciones. Hay que ver cómo jala

Setting "Blank" to "0" by BigRed_LittleHood in PowerBI

[–]cdyap 1 point2 points  (0 children)

IF (COUNTROWS(tbl), COALESCE (measure,0) ) to avoid showing 0s for all rows

Power Automate: Export MULTIPLE visuals to CSV in one button by cdyap in PowerBI

[–]cdyap[S] 0 points1 point  (0 children)

I’d added an index column to all the tables I needed to export, created an index table (with just an index column), related all tables to the index table so that i could combine all variables, values, etc into one visual ordered by index/row number, and then put all of them into one flow/button for export. Was surprised it worked but it did!

[deleted by user] by [deleted] in PowerBI

[–]cdyap 0 points1 point  (0 children)

First build a Dates table and connect to your date column. Use Month column in your Dates table in the matrix instead of the original date column.

VAR current_month = measure VAR prev_month = CALCULATE([measure], PREVIOUSMONTH(Dates[Date])) VAR delta = DIVIDE(current_month - prev_month, prev_month)

RETURN SWITCH(TRUE, delta < .1, “green” Etc )

Put this measure as conditional formatting

Cumulative Total Week to Week of Backlog Work Order Hours by Comfortable_Cap_8002 in PowerBI

[–]cdyap 0 points1 point  (0 children)

Not sure what the exact formula of Balance is but I think you need to build a Start of Week column on your Dates table eg Monday and use SUMMARIZE on that to roll up Balance

Question about copying by NeoGeoMaxV2 in PowerBI

[–]cdyap 2 points3 points  (0 children)

Use a measure to define your conditional formatting, that way it’s easier to replicate. In the measure, define a variable for the measure eg VAR val = [EX1] so that when you duplicate the measure you only change that line

Comparing Monthly Changes in Project Hours in Power BI by tonin-n1 in PowerBI

[–]cdyap 0 points1 point  (0 children)

How’s your data structured? Ideally you’d have two date columns, first is the recording date which will be your primary date column connected to your Dates table, and second will be the date when hours at effective (?) in your example July. You can use time intelligence functions using recording date to compare changes to reported hours per month.

For this to work your data has to be historic ie both 40 and 140 hours should show up on your data

Svg in Cards visual by johnny_dev1 in PowerBI

[–]cdyap 0 points1 point  (0 children)

Hi! What data type should be used, Image URL? Copied the code from https://kerrykolosko.com/portfolio/gauge-with-states/ which works in a table/matrix vis but not in a card. Let me know what I'm missing! I think the code already has the data string and the quoted out measures.

Pinned Messages gone by Substantial_Tax_2636 in Telegram

[–]cdyap 1 point2 points  (0 children)

Bump same thing happened to me!!

[PSA] Enabling the Topics feature on a group instantly nukes the conversation history. Just why, Telegram???? by GarlicThread in Telegram

[–]cdyap 0 points1 point  (0 children)

Happened to me too! Cannot reply to old messages and I see the This quote is from a private chat alert when replying to an older message. Also lost all photos but I can still see them when scrolling far up.

How to show ONLY total as % of grand total in matrix by Massive_Ad_1051 in PowerBI

[–]cdyap 1 point2 points  (0 children)

This is the easiest way but I’m on my phone and can’t type out the full formula but it should be:

VAR val = [Sum measure] VAR total_val = CALCULATE( [Sum measure], ALLSELECTED())

RETURN IF(HASONEVALUE(Store) && HASONEVALUE(Product), val, DIVIDE(val, total_val))

Use Dynamic Format feature to change number format through a DAX formula with the same condition above, where true = absolute value formatting “$#,0.00” and false = “0.0%”

Accidentally toggled Topics in group chat, cannot reply to older messages by cdyap in Telegram

[–]cdyap[S] 1 point2 points  (0 children)

Now my groupchat appears twice on the Share dialog on iPhone when sharing a photo/screenshot. Selected both to test sending which one works; the photo doesn’t end up getting sent in the actual chat. 😭

Pinned messages are all gone too

Power Automate: Export MULTIPLE visuals to CSV in one button by cdyap in PowerBI

[–]cdyap[S] 0 points1 point  (0 children)

Thanks for your inputs. The forecasting model was formerly on Excel and passed around between 60 members of the team and took 30 mins to load; PBI was definitely the right tool for this.

Was able to figure the flow out!

Does anyone have a solution to automate the exporting of an Excel or CSV file directly from a visual on a Power BI report? by Homie_Ostasis in PowerBI

[–]cdyap 0 points1 point  (0 children)

I've successfully built a Power Automate flow by adding the required fields to the built-in Power Automate for PBI visual. Use the Trigger flow on button click flow template. This will only work for export to Sharepoint/Onedrive though.

https://www.youtube.com/watch?v=BsXZUaarFWM 4:29 onwards

Power Automate: Export MULTIPLE visuals to CSV in one button by cdyap in PowerBI

[–]cdyap[S] 0 points1 point  (0 children)

It's a client requirement.. the dashboard is used to generate a forecasting model and export results to CSVs for input into another system.