Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23

Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31

Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20

Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
{"id":6728,"date":"2024-04-18T02:11:00","date_gmt":"2024-04-18T09:11:00","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=6728"},"modified":"2024-04-18T02:11:00","modified_gmt":"2024-04-18T09:11:00","slug":"when-sorting-fails-dynamic-formatting-mistakes-with-measures","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2024\/04\/when-sorting-fails-dynamic-formatting-mistakes-with-measures\/","title":{"rendered":"When Sorting Fails: Dynamic Formatting mistakes with Measures"},"content":{"rendered":"

Have a measure that you want to format as a string in Power BI? But then the sorting doesn’t work on it? What do you do? You can’t sort by column with Measures. Patrick shows you how you can leverage Dynamic Formatting!<\/p>\n

Create dynamic format strings for measures
\nhttps:\/\/learn.microsoft.com\/power-bi\/create-reports\/desktop-dynamic-format-strings<\/a><\/p>\n

Zoe Douglas:
\n
https:\/\/twitter.com\/datazoepowerbi<\/a>
\n
https:\/\/www.linkedin.com\/in\/zoedouglas-data\/<\/a><\/p>\n

Phil Seamark:
\n
https:\/\/twitter.com\/PhilSeamark<\/a>
\n
https:\/\/www.linkedin.com\/in\/seamark\/<\/a><\/p>\n

\ud83d\udce2 Become a member: https:\/\/guyinacu.be\/membership<\/a> <\/p>\n

*******************<\/p>\n

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.<\/p>\n

\ud83c\udf93 Guy in a Cube courses: <a href="https:\/\/guyinacu.be\/courses" target=”_blank” rel=”nofollow”>https:\/\/guyinacu.be\/courses<\/a><\/p>\n

*******************
\nLET’S CONNECT!
\n*******************<\/p>\n

http:\/\/twitter.com\/guyinacube<\/a>
\n—
http:\/\/twitter.com\/awsaxton<\/a>
\n—
http:\/\/twitter.com\/patrickdba<\/a>
\n—
http:\/\/www.facebook.com\/guyinacube<\/a>
\n—
https:\/\/www.instagram.com\/guyinacube\/<\/a>
\n—
https:\/\/guyinacube.com<\/a><\/p>\n

***Gear***
\n\ud83d\udee0 Check out my Tools page –
https:\/\/guyinacube.com\/tools\/<\/a><\/p>\n

#PowerBI #DAX #GuyInACube<\/p>\n","protected":false},"excerpt":{"rendered":"

Have a measure that you want to format as a string in Power BI? But then the sorting doesn’t work on it? What do you do? You can’t sort by column with Measures. Patrick shows you how you can leverage Dynamic Formatting! Create dynamic format strings for measures https:\/\/learn.microsoft.com\/power-bi\/create-reports\/desktop-dynamic-format-strings Zoe Douglas: https:\/\/twitter.com\/datazoepowerbi https:\/\/www.linkedin.com\/in\/zoedouglas-data\/ Phil Seamark: […]<\/p>\n","protected":false},"author":3,"featured_media":6730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2024\/04\/zspWD9Cx1UI.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1Kw","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6728"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=6728"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6728\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/6730"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=6728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=6728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=6728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}