need a help
12 Topicshow to covert date format when open published the report with other user
Hi Team, i have a new requirement i have created sales report in that added the slicer as a date format in showing is 12/11/2025(DD/MM/YYYY) but when the user open the sales report organizational workspace the date format is showing 11/12/2025(MM/DD/YYYY) Is there any way avaialble what ever we create same format can view. thanksSolved1.1KViews1like6Commentshow to show date and time both in same slicer in power bi
Hi Team, i came cross the requirement to show the date and time (30/06/2025 15:12:36) in power bi slicer as like below , refer the below screenshot for your references Currently showing below is the format and along with date i need to show time . please check and share me the detailsSolved1.8KViews1like9Commentshow to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi
hi Team, i have created dataflow and connected into the power bi now planning to change dateformat mm/dd/yyyy to dd/mm/yyyy in power bi , so i have tried in power query here the screenshot for your refrences input is used it IST_system_order_time is mm/dd/yyyy and in power query itself converted format another yellow marked and here is showed required result but when i applied slicer it showing same way like mm/dd/yyyy Where iam missing/ any missing / please check and let us knowSolved2.8KViews0likes8Commentshow to combined skill with separe with (comma)
Hi Team,, Just want to check with you on the requirement we want to create below result Real case question:- Name Skill Naveen SQL Naveen Azure Naveen Power bi Srinivas MSBI Srinivas SQL Srinivas Power Bi Final Result is ;- Name skill Naveen SQL,Azure,Power Bi Srinivas MSBI,SQL,Power Bi Please check and provide any feasible option on the DAX ??Solved1.3KViews0likes7Commentshow to make 3 columns added in dax with filter
hi Team, Requesting please check below concern and do the needful. i have a Event_type fileld in that many classification but i need to add 3 columns to caclualte cont of orders Order quantity = event_type(OUTWARD_ORDER_CANCEL) + event_type( OUTWARD_ORDER_COMPLETE) + event_type( OUTWARD_ORDER_SHIPMENT_DISPATCH) is that possible make one dax expression ???? finaly i need all 3 columns should be added and show total orders Below DAX i have used but getting wrong count values , please fix it is possible Order quantity = CALCULATE( COUNTROWS(order_items), FILTER( order_items, RELATED(outward_orders[event_type]) <> "OUTWARD_ORDER_CANCEL" && RELATED(outward_orders[event_type]) <> "OUTWARD_ORDER_COMPLETE" && RELATED(outward_orders[event_type]) <> "OUTWARD_ORDER_SHIPMENT_DISPATCH " ))Solved473Views0likes1Commenthow to get hour in date & time field
Hi Team, i have connected semantic model to power bi Desktop and the now requirement is when the date & time have ,,, i need only hour in that how i can get that. Date 01-08-2024 10:16 01-08-2024 11:50 01-08-2024 14:43 01-08-2024 17:00 01-08-2024 11:30 I would expect to see 10, 11 for second row, 14 for the thirid 17 for the fourth and 11 for the fifth . Please check and share any way we can achive on above concern. Thanks,Solved707Views0likes2CommentsParse issue - DataFromat.Error
Hey guys, Is there a way to get the value for WHATIWANTTOGET which is 12345 using DAX? Tried to parse the column via Power Query but I'm getting "DataFormat.Error" We reached the end of the buffer. [{"xxx":"UNA","xxx":"21","xxx":"UNA","xxx":"aaa","xxx":"1","xxx":"2","xxx":"12","WHATIWANTTOGET":"12345","XXX":"1234","XXX":"UNA","XXXX":"UNA"}] Note that the position always changes. Only keyword is WHATIWANTTOGET.Solved1.1KViews0likes5CommentsInsert sum of hours measure in chart
Hello, I try to put a sum of hours measure in a char, but I can't. I have this base: Type Duration (hh:mm:ss) 1 00:03:00 1 00:03:00 1 00:03:00 2 00:04:00 2 00:04:00 2 00:04:00 3 00:02:00 3 00:04:00 3 00:03:00 Measure(total) 0:30:00 The measure is the sum of duration (hh:mm:ss) My line chart need to show this info: Type 1 = 00:09:00 - Type2 = 00:12:00 - Type3 = 00:09:00 I need something like this. Anyone can help me?? Thanks a lot.Solved537Views0likes2Comments