Thanks for Sharing, I have been looking for how to get this done without using bookmarks. Appreciate you taking time to upload and share your knowledge
@RobertoStaltari thank you so much!!! Please have your team subscribe as well and thank you for your support!! If there is any topic I could cover for you please let me know!
Done with my first attempt! Looks good, looking forward to learning more. Do you have videos for visualizations related to showing organizational charts?
So happy to hear that you are looking forward to learning more and thank you for this comment!!! Yes I definitely have a video pertaining to organization charts, check this out below! Mastering Power BI PARENT CHILD Hierarchy: A Complete Guide!!! th-cam.com/video/iwRqSl-_zvU/w-d-xo.html
Thank you for the video, it helped me to build something similar!!! One question, sometimes the data field under value option is grayed out, do you know why?
Thank you for sharing and I'm happy to hear the video helped you build something similar! For your question, can you provide a little bit more detail to help with troubleshooting? Specifically, what are you referring to pertaining to "value option"? If you traverse the visual's formatting menu, which specific field. Example.. [Callout values] -> [Values] -> [Show blank as]. With this additional detail I'll be happy to look into it and see how I can help!
Thanks for sharing how you enjoyed this video!! Great question, for the concept of this video, the clickable cards will function by filtering on field only but there is a way to filter on a measure value outside of this presented concept. It would be to utilize the filter pane on the visual using a filter for the measure applied to the visual. This is because measures are calculated by whichever filter context is applied, so they cannot be utilized the same way categorical values are.
Glad it's useful and thanks for your question!! Yes, if you are referring to a text field with the value of "ZERO" and you'd like to show "Zero" you can do that in the transform layer. Either change the actual value, or duplicate the column and use it just for the filter and format as needed. Here's a blog about it. community.fabric.microsoft.com/t5/Desktop/How-to-convert-text-to-Title-Case-Proper-Case-CamelCase/m-p/166037#M72484 In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word. If you are referring to the int "0" and wanting to return string "Zero". I would update your calc to return blank instead of "0", then in the callout value, set the show blank as field to "Zero".
I believe for this update I had either the Feb or Mar version installed. I recommend you download the most recent version, the majority of this tutorial does use some of the newest features
Great question and thanks for reaching out! Currently this slicker does not allow for reference labels (which could used to add a target value), or detail labels. Currently, you'll only be able to display a callout value to my knowledge. If you find a workaround or another way to solve adding targets please do share!
Excellent question! For this specific card visual, it will only function with one column of data. You can try a couple of different/creative solution options utilizing multiple filters though. Maybe create a another slicer of some-type for the other columns, or create a KPI filter for each of the columns you want to filter on. Hope this helps and let me know what you decide to go with!
Love this - anyone know how to make the clickable cards / filters from going invisible if there is no data? using another filter on the side makes them disapear if there is no data.
Great question and glad you love it!! I think that’s a drawback of using the filter, as items are filtered they are removed from all filters. You may be able to construct something where a dummy visual/image is behind the actual one, so if items drop the visual behind appears. Brainstorming… haven’t tried it yet
Hi and thanks for the question! In order for a filter to show any value, it needs to have some type of dataset related to it. Under the callout values section, there is section "Show blank as". If you have dataset that is completely null or empty, you can update this "Show blank as" box to "0" and if the dataset is completely empty (null) it will return a zero. Hopefully this helps and thank you for your questions!
@@PowerBIBro Thanks for this great video and also thanks for sharing your knowledge. Meanwhile a follow-up question, if the value which is under "Label" is getting filtered to 0, the slicer gets reshaped and panel gets changed. How to avoid slicer to get reshaped if the "Label" is 0 due to another filter? Thanks in advance for our comments.
So it's basically new slicer and not "cards" - yes you format them to look like card - still a kind of “clickbait” title - otherwise good video ;-) Question to "formatting" measure - why don't use formatting option "currency, tsd., decimals" above in the menue instead of using format in the measure code?
Thanks for the feedback and the question! You're totally correct about how this video focuses on converting the slicer tool to appear as a card. My thought was positioning the "card" concept from the viewpoint of the end-user vs developer. Great formatting question. The label field within the callout value section doesn't translate the default formatting applied to the measure "currency, etc..". To test it, if you download the file from github, drop the Net Sales field onto the label (field without the DAX Format function), and you'll see that applied default formatting doesn't pass through. Currently for this label feature, we need to declare the formatting with the the DAX measure itself. Thanks again for your question and support!
Yes after checking the video I assume it to more than 1 year. New features are already added in pbi. So no need to add measure again. It would be again storage problem
Not really a secret, the new slicer is supposed to do that, act as a slicer and apply filters when clicked. The new card visual is still not clickeable or interactive
True, the goal of the concept is to share how we can manipulate slicers through a series of formatting steps and label measures to appear as clickable KPI cards to our end-users. Thanks for the feedback!
I love it, thanks!!
Thank you for sharing!!
Thanks for Sharing, I have been looking for how to get this done without using bookmarks. Appreciate you taking time to upload and share your knowledge
Awesome!! My pleasure and thanks for sharing!!
Easy and effective. And no bookmarks! Pure gold. Thanks!
Thank you for sharing and for your support!
@@PowerBIBro I'm actually sharing your videos with my team and the reaction is always the same: wooow! :)
@RobertoStaltari thank you so much!!! Please have your team subscribe as well and thank you for your support!!
If there is any topic I could cover for you please let me know!
Done with my first attempt! Looks good, looking forward to learning more. Do you have videos for visualizations related to showing organizational charts?
So happy to hear that you are looking forward to learning more and thank you for this comment!!!
Yes I definitely have a video pertaining to organization charts, check this out below!
Mastering Power BI PARENT CHILD Hierarchy: A Complete Guide!!!
th-cam.com/video/iwRqSl-_zvU/w-d-xo.html
Thank you for the video, it helped me to build something similar!!! One question, sometimes the data field under value option is grayed out, do you know why?
Thank you for sharing and I'm happy to hear the video helped you build something similar! For your question, can you provide a little bit more detail to help with troubleshooting? Specifically, what are you referring to pertaining to "value option"? If you traverse the visual's formatting menu, which specific field. Example.. [Callout values] -> [Values] -> [Show blank as]. With this additional detail I'll be happy to look into it and see how I can help!
Well done video and explanations. Is there a way to filter by both the field and the label value?
Thanks for sharing how you enjoyed this video!!
Great question, for the concept of this video, the clickable cards will function by filtering on field only but there is a way to filter on a measure value outside of this presented concept. It would be to utilize the filter pane on the visual using a filter for the measure applied to the visual. This is because measures are calculated by whichever filter context is applied, so they cannot be utilized the same way categorical values are.
Thanks bro.. it is very useful..
Would like to ask what if the value is ZERO, can the Label show Zero?
Tqvm
Glad it's useful and thanks for your question!!
Yes, if you are referring to a text field with the value of "ZERO" and you'd like to show "Zero" you can do that in the transform layer. Either change the actual value, or duplicate the column and use it just for the filter and format as needed. Here's a blog about it.
community.fabric.microsoft.com/t5/Desktop/How-to-convert-text-to-Title-Case-Proper-Case-CamelCase/m-p/166037#M72484
In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word.
If you are referring to the int "0" and wanting to return string "Zero". I would update your calc to return blank instead of "0", then in the callout value, set the show blank as field to "Zero".
What version of Power BI do I need for this? I dont see the formatting options for cards on mine.
I believe for this update I had either the Feb or Mar version installed. I recommend you download the most recent version, the majority of this tutorial does use some of the newest features
Can't wait to try this one
Awesome enjoy!!
This is awesome! Thank you so much!
Thank you, my pleasure!!
Can you also add a target value to these?
Great question and thanks for reaching out! Currently this slicker does not allow for reference labels (which could used to add a target value), or detail labels. Currently, you'll only be able to display a callout value to my knowledge. If you find a workaround or another way to solve adding targets please do share!
Great stuff. Thx for the tips
Thank you!!
Thanks
My pleasure!
Is there a way of using this with multiple columns, where you have data that falls into multiple categories?
Excellent question! For this specific card visual, it will only function with one column of data. You can try a couple of different/creative solution options utilizing multiple filters though. Maybe create a another slicer of some-type for the other columns, or create a KPI filter for each of the columns you want to filter on. Hope this helps and let me know what you decide to go with!
Amazing! Thanks!
My pleasure!!
Love this - anyone know how to make the clickable cards / filters from going invisible if there is no data? using another filter on the side makes them disapear if there is no data.
Great question and glad you love it!!
I think that’s a drawback of using the filter, as items are filtered they are removed from all filters.
You may be able to construct something where a dummy visual/image is behind the actual one, so if items drop the visual behind appears.
Brainstorming… haven’t tried it yet
This is so awesome will try soon and update you how it went
Awesome! I look forward to hearing from you!
Thank you for sharing the tips
My pleasure, thank you for your support!!
One quick check..when there is no data set related to new slicer, It dissapears. How can we make it to show count zero instead of dissapearing?
Hi and thanks for the question! In order for a filter to show any value, it needs to have some type of dataset related to it. Under the callout values section, there is section "Show blank as". If you have dataset that is completely null or empty, you can update this "Show blank as" box to "0" and if the dataset is completely empty (null) it will return a zero.
Hopefully this helps and thank you for your questions!
@@PowerBIBro Thanks for this great video and also thanks for sharing your knowledge. Meanwhile a follow-up question, if the value which is under "Label" is getting filtered to 0, the slicer gets reshaped and panel gets changed. How to avoid slicer to get reshaped if the "Label" is 0 due to another filter? Thanks in advance for our comments.
So it's basically new slicer and not "cards" - yes you format them to look like card - still a kind of “clickbait” title - otherwise good video ;-)
Question to "formatting" measure - why don't use formatting option "currency, tsd., decimals" above in the menue instead of using format in the measure code?
Thanks for the feedback and the question! You're totally correct about how this video focuses on converting the slicer tool to appear as a card. My thought was positioning the "card" concept from the viewpoint of the end-user vs developer.
Great formatting question. The label field within the callout value section doesn't translate the default formatting applied to the measure "currency, etc..". To test it, if you download the file from github, drop the Net Sales field onto the label (field without the DAX Format function), and you'll see that applied default formatting doesn't pass through. Currently for this label feature, we need to declare the formatting with the the DAX measure itself.
Thanks again for your question and support!
Yes after checking the video I assume it to more than 1 year. New features are already added in pbi. So no need to add measure again. It would be again storage problem
Not really a secret, the new slicer is supposed to do that, act as a slicer and apply filters when clicked. The new card visual is still not clickeable or interactive
True, the goal of the concept is to share how we can manipulate slicers through a series of formatting steps and label measures to appear as clickable KPI cards to our end-users. Thanks for the feedback!
Looks great! Thank you!
Awesome! Thanks for your support!!